access/foxpro: select iif(sex,="1","男","女") as xb from user
orcle: select decode(sex,1,'男','女') from user
sqlserver: select sex=case when sex=0 then '男' when sex=1 then '女' end from user
或 select sex=substring('男女',sex+1,1) from user
阳光VIP少壮不努力，老大徒伤悲。平日弗用功，自到临期悔。 |
