| 用了${switch} 但是想起个别名，不知道怎么办，求大神帮助 select useyear,usemonth, ${switch(p_jb,1,"syb ",2,"dept1 ")} ---这里想起个别名用在图表系列里，不知道怎么弄的都不对就像${switch(p_jb,1,"syb ",2,"dept1 ")} as"dept" ,count(fnumber) as rs from hr_entryjob_v where syb not in('null') and useyear=${s_year} and usemonth=${s_month} and deptid in( select deptid from pub_dept start with deptid='${p_deptid}' connect by parentdeptid=prior deptid) group by useyear,usemonth,${switch(p_jb,1,"syb ",2,"dept1 ")} order by useyear,usemonth |
