16,549
社区成员
发帖
与我相关
我的任务
分享
SELECT 教师ID
FROM (
SELECT DISTINCT [1、2节教师ID] AS 教师ID, 1 AS 节 FROM 表1 WHERE [1、2节教师ID] IS NOT NULL
UNION ALL
SELECT DISTINCT [3、4节教师ID] AS 教师ID, 3 AS 节 FROM 表1 WHERE [3、4节教师ID] IS NOT NULL
UNION ALL
SELECT DISTINCT [5、6节教师ID] AS 教师ID, 5 AS 节 FROM 表1 WHERE [5、6节教师ID] IS NOT NULL
UNION ALL
SELECT DISTINCT [7、8节教师ID] AS 教师ID, 7 AS 节 FROM 表1 WHERE [7、8节教师ID] IS NOT NULL
) AS T
GROUP BY 教师ID
HAVING COUNT(节) = 4;