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
Powered by: 博客园 Copyright © 2025 阳光VIP Powered by .NET 9.0 on Kubernetes