# case when的表达式形式
## 1. 简单Case函数
“`
CASE sex
WHEN ‘1’ THEN ‘男’
WHEN ‘2’ THEN ‘女’
ELSE ‘其他’ END
“`
## 2. Case搜索函数
“`
CASE
WHEN sex = ‘1’ THEN ‘男’
WHEN sex = ‘2’ THEN ‘女’
ELSE ‘其他’ END
“`
# 在不同位置的用法
## 1. select case when 用法
“`
计算男女占比
SELECT
SUM(
CASE
WHEN sex=1 THEN 1
ELSE 0
END
) AS boy,
SUM(
CASE
WHEN sex=2 THEN 1
ELSE 0
END
) AS girl,
ROUND(boy/(boy+girl), 3) as rate1,
ROUND(girl/(boy+girl), 3) as rate2
FROM user_profile_all;
————————————–
boy girl rate1 rate2
139220493
版权声明：本文为weixin_42345187原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。