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
博客园 © 2004-2025 浙公网安备 33010602011771号 浙ICP备2021040463号-3