使用帆软总结-同一sql实现多种维度查询

1.开发界面设计

方便伙伴们复制：

SELECT 
${if(len(Q) = 0 &&len(month) = 0,"year||'年' year_month,","year,")}
${if(len(Q) = 0,"","year||'年Q'||Q year_month,")}
customer_name
FROM 
(select 2023 year,3 Q, 09 month,'客户1' customer_name from dual
union all 
select 2024 year,1 Q, 01 month,'客户2' customer_name from dual)
WHERE 1=1 
${if(len(year) = 0,"","and year in ( " + year + ")")}
${if(len(customer_name) = 0,"","and customer_name in ( '" + customer_name+ "')")}
group by year,customer_name
${if(len(Q) = 0,"",",Q")}
order by year
${if(len(Q) = 0,"",",Q")}

2.效果演示