读书人

SQL查询时某一列不重复(先对先得)解

发布时间: 2012-02-15 12:09:44 作者: rapoo

SQL查询时某一列不重复(先对先得)
SELECT DISTINCT OverTimeHead.ApplyNo, OverTimeList.OverTimeListId
FROM OverTimeHead INNER JOIN OverTimeList ON OverTimeHead.OverTimeHeadId = OverTimeList.OverTimeHead
我要Apply不重复

[解决办法]
SELECT DISTINCT OverTimeHead.ApplyNo
FROM OverTimeHead INNER JOIN OverTimeList ON OverTimeHead.OverTimeHeadId = OverTimeList.OverTimeHead

读书人网 >C#

热点推荐