数据库中存储的性别是1和2，查询的时候怎么让1和2变成男，女显示出来。
问题如题

[解决办法]
select case when 性别 = 1 then '男' when 性别 = 2 then '女' else '不男不女' end from tb
[解决办法]
select case when 字段=1 then '男' else '女' from tb
[解决办法]

SQL code

if object_id('people') is not null    drop table peoplegocreate table people(ID int, Sex int)goinsert into peopleselect 1, 1 union allselect 2, 1 union allselect 3, 2 union allselect 4, 2goselect ID, Sex=(case Sex                 when 1 then '男'                 when 2 then '女'                else ''                end)            from people/*ID          Sex----------- ----1           男2           男3           女4           女*/
[解决办法]
探讨


select case when 性别 = 1 then '男' when  性别 = 2 then '女' else '不男不女' end from tb

[解决办法]
select  case when 1 then 男 else  女 end
from  tb
[解决办法]
探讨


select case when 性别 = 1 then '男' when  性别 = 2 then '女' else '不男不女' end from tb

[解决办法]
select case when 性别 = 1 then '男' when 性别 = 2 then '女' else '待定' end from tb
[解决办法]
case 性别 when 1 then '男' when 2 then '女' end
[解决办法]
探讨


select case when 性别 = 1 then '男' when  性别 = 2 then '女' else '不男不女' end from tb