2021-06-18
case when语句的使用
一、
SELECT USER
.USERNAME,
USER.HEADPORTRAIT,
USER.NAME,
CASE WHEN SEX =1 THEN ‘男’
WHEN SEX =2 THEN ‘女’
ELSE ‘其他’
END AS SEX
FROM
sys_user USER
另一种写法:
SELECT USER
.USERNAME,
USER.HEADPORTRAIT,
USER.NAME,
CASE SEX WHEN 1 THEN ‘男’
WHEN 2 THEN
原创
2021-06-18 15:11:02 ·
62 阅读 ·
0 评论