查询某字段不重复记录的SQL语句

查询文章信息articleInfo表中的articleAuthor字段不重复记录的SQL如下：

SELECT *
FROM articleInfo AS A
WHERE articleID IN
(SELECT top 1 articleID
FROM articleInfo AS B
WHERE A.articleAuthor = B.articleAuthor)

 

 

 

SELECT *
FROM articleInfo
WHERE articleID IN
(SELECT max(articleID)
FROM articleInfo
Group By articleAuthor)

 

max()

min()

转载于:https://blog.51cto.com/332374363/903841