1维表转2维表 2

分类: IT文章 • 2024-09-05 22:56:43

一维表转2维表 2

SELECT t_no , SUM(CASE WHEN w_no=1 THEN 1 END) AS 星期一,
SUM(CASE WHEN w_no=2 THEN 1 END) AS 星期二,
SUM(CASE WHEN w_no=3 THEN 1 END) AS 星期三
FROM teacher_class
GROUP BY t_no