SQL中case的用法（转）

最新推荐文章于 2024-11-18 14:51:17 发布

ziyouhuxi0

最新推荐文章于 2024-11-18 14:51:17 发布

阅读量517

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/ziyouhuxi0/article/details/1413859

版权

[ <<label_name>> ]
CASE { WHEN boolean_expression THEN {statement;} ... }...
[ ELSE {statement;}... ]
END CASE [ label_name ];

simple_case_statement ::=

[ <<label_name>> ]
CASE case_operand
{ WHEN when_operand THEN {statement;} ... }...
[ ELSE {statement;}... ]
END CASE [ label_name ];[separator]

'--------------------------------------------------------------------------------------
1.select cust_last_name,
CASE credit_limit WHEN 100 THEN 'Low'
WHEN 5000 THEN 'High'
ELSE 'Medium' END
FROM customers;
它相当于用switch
2.select AVG(CASE WHEN e.salary > 2000 THEN e.salary
ELSE 2000 END) "Average Salary" from employees e;

它则相当于用if