|
楼主 |
发表于 2017-7-20 16:51
|
显示全部楼层
我根据我实际的数据改了你的SQL语句,但是报错,不知道错在哪里,帮忙看一下 谢谢
- select *,iif(等级="G" or 等级="M" or 等级="E" or 等级="N" or ,"等级",iif(等级="<1" or or 等级="1-2" or 等级="3-4" or 等级="5-10" or 等级=">10","司龄","年龄")) as 筛选 from (select 等级,iif(区域="East China",1) as 'East China',iif(区域="North China",1) as 'North China',iif(区域="South China",1) as 'South China' from [信息表$] union all select iif(年龄<21,"<21",iif(年龄>=21 and 年龄<=30,"21-30",iif(年龄>=31 and 年龄<=40,"31-40",iif(年龄>=41 and 年龄<=50,"41-50",">50")))),iif(区域="East China",1) as 'East China',iif(区域="North China",1) as 'North China',iif(区域="South China",1) as 'South China' from [信息表$] union all select [司龄],iif(区域="East China",1) as 'East China',iif(区域="North China",1) as 'North China',iif(区域="South China",1) as 'South China' from [信息表$])
复制代码 |
|