526互联

SQL笔记-case when 与left()和in()组合使用

发布时间 2023-06-12 15:52:32作者: 雾霭雾海

SELECT a.co1

   ,CASE WHEN LEFT(hangye,2)in(13,14,15,16) THEN '食品'

         WHEN LEFT(hangye,2)in(17,18,19,28) THEN '纺织' ELSE '其他' END AS Leixing

   ,a.zhandi

   ,shuishou

   ,xiaoshou

FROM table1 a

WHERE 1 = 1 作者：志城 https://www.bilibili.com/read/cv9186138/ 出处：bilibili

自己写的：
SELECT count(1),case when FPGCDM in ('00007','00025','00026','00027') then '人南校区'
when FPGCDM in ('00012','00023','00024','2301') then '彭州校区'
when FPGCDM = '00014' then '宜宾校区'
else '本部校区' end as XQ
from bigdata_book_information
WHERE RCRQ <= CONCAT(YEAR(NOW()) - 1, "0831") and skztm not in ('34','35','36','37','38','3B','3c')
GROUP BY XQ