select aa=(case when 职称='高' then 3 else (case when 职称='中' then 2 else (case when 职称='初' then 1 else 0))) from yourTab order by aa数据库为Access时更简单,直接用iif函数。
select (case 职称 when '高' then 3 when '中' then 2 when '初' then 1 else 0 end) as AA,* from myTable order by aa
else (case when 职称='中' then 2
else (case when 职称='初' then 1 else 0)))
from yourTab order by aa数据库为Access时更简单,直接用iif函数。
access好象不能用case,它出错
谢谢了!!!!!!!!!
select (iif(职称='高',3,(职称='初',2,1))) as XL from yourTab where ... order by XL
select zhicheng from lable
order by iif(zhicheng='高','1',iif(zhicheng='中','2','3'))还是“行者”这个高人厉害!!
行者麻烦在这儿回个帖,谢了