SQL查询时某一列不重复（先对先得）

Question

SELECT DISTINCT OverTimeHead.ApplyNo, OverTimeList.OverTimeListId
FROM OverTimeHead INNER JOIN OverTimeList ON OverTimeHead.OverTimeHeadId = OverTimeList.OverTimeHead
我要Apply不重复

Answer 1

SELECT min(OverTimeHead.ApplyNo), OverTimeList.OverTimeListId
FROM OverTimeHead INNER JOIN OverTimeList ON OverTimeHead.OverTimeHeadId = OverTimeList.OverTimeHead
GROUP BY OverTimeList.OverTimeListId

Answer 2

不是拉，还是有重复的俄Apply出现

Answer 3

SELECT DISTINCT OverTimeHead.ApplyNo
FROM OverTimeHead INNER JOIN OverTimeList ON OverTimeHead.OverTimeHeadId = OverTimeList.OverTimeHead

Answer 4

晕阿， OverTimeList.OverTimeListId还是要的阿