oracle case when 查询判断样例

查询student表中 男性总年龄 - 女性总年龄
case 字段 when 判断条件 then() else end 结束判断条件
case 相当于if when 相当于(条件 then) else
select sum(case student_sex when 1 then student_age
else 0 end) - sum(case student_sex when 2
then student_age else 0 end
) from t_student
select sum(student_age),student_sex
from t_student group by student_sex

select * from t_student
–根据student_sex 字段 展示具体性别
–(case student_sex when 1 then
–‘男’ else '女’end) 临时列 字段类型随意
select t_student.,(case student_sex when 1 then
‘男’ else '女’end) as sex from t_student
select t_student.,‘今天天气不错’ as spring
from t_student
–if()else if() else
select student_age,(case when student_age>=18 and student_age<30 then ‘成年’
–默认使用=
when student_age>=30 then ‘成年很久了’
when student_age<18 then ‘未成年’
else ‘其他’ end)
as ageDesc from t_student