--方法2:
SELECT * FROM #temp a
WHERE NOT EXISTS
(
SELECT 1
FROM #temp b
WHERE b.[课程编号] = a.[课程编号]
AND b.星期 < a.星期
)
SELECT * FROM #temp a
WHERE NOT EXISTS
(
SELECT 1
FROM #temp b
WHERE b.[课程编号] = a.[课程编号]
AND b.星期 < a.星期
)
SELECT b.* FROM
(SELECT DISTINCT [课程编号] FROM #temp) a
CROSS APPLY
(SELECT TOP(1) * FROM #temp m WHERE m.[课程编号] =a.[课程编号] ORDER BY 星期) b