可以。在SQL中使用下拉单元格中输入的值。
SELECT 地区 ${if(len(销售员)=0,"",",销售员")} ${if(len(产品类型)=0,"",",产品类型")} ${if(len(产品)=0,"",",产品")} ,sum(销量) as 销量汇总 FROM 销量where 1=1 ${if(len(销售员)==0,"","and 销售员 in ('" +销售员+ "')")} ${if(len(产品类型)==0,"","and 产品类型 in ('" +产品类型+ "')")} ${if(len(产品)==0,"","and 产品 in ('" +产品+ "')")} group by 地区 ${if(len(销售员)=0,"",",销售员")} ${if(len(产品类型)=0,"",",产品类型")} ${if(len(产品)=0,"",",产品")}
1min目标场景问卷
立即参与
我想在 SQL 中使用下拉单元格中输入的值。可以吗？
