case语句

scan724

于 2014-01-01 21:44:26 发布

阅读量577

点赞数

分类专栏： sql cookbook

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/17738977

版权

sql cookbook 专栏收录该内容

59 篇文章 30 订阅 ¥39.90 ¥99.00

订阅专栏

这篇博客展示了如何在 SQL 中使用 CASE 语句进行条件判断，通过示例查询了员工薪资，将薪资分为 'UNDERPAID'、'OK' 和 'OVERPAID' 三个类别。

摘要由CSDN通过智能技术生成

SQL>   select ename,sal,
               case when sal <=2000 then 'UNDERPAID'
                    when sal >= 4000 then 'OVERPAID'
                    else 'OK'
       end as sal
      from emp;  2    3    4    5    6  

ENAME		  SAL SAL
---------- ---------- ---------
SMITH		  800 UNDERPAID
ALLEN		 1600 UNDERPAID
WARD		 1250 UNDERPAID
JONES		 2975 OK
MARTIN		 1250 UNDERPAID
BLAKE		 2850 OK
CLARK		 2450 OK
SCOTT		 1500 UNDERPAID
KING		 5000 OVERPAID
TURNER		 1500 UNDERPAID
ADAMS		 1100 UNDERPAID

ENAME		  SAL SAL
---------- ---------- ---------
JAMES		  950 UNDERPAID
FORD		 3000 OK
MILLER		 1300 UNDERPAID

14 rows selected.