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

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