求助--关于Select筛选重复的查询结果……

[ckxp]

语句是这样写的：
SELECT TOP 10 u.NetName，u.UserName FROM diaryUser u INNER JOIN diaryData d ON d.UserID=u.UserID ORDER BY d.DiaryID DESC

结果是这样的：

药师琉璃光
药师琉璃光
药师琉璃光
淼渺
彼岸花
卡卡柠檬
乱．暮沄春澍
乱．暮沄春澍
乱．暮沄春澍
乱．暮沄春澍

有什么方法可以不重复显示，跳过去继续查询吗？
确保u.UserID 不重复

[ckxp]

SELECT distinct TOP 40 d.DiaryID,u.NetName,u.SortCount,u.BlogCount,u.UserName FROM diaryUser u INNER JOIN diaryData d ON d.UserID=u.UserID WHERE d.DiaryLock=0 AND d.DiaryHidden=0 ORDER BY d.DiaryID DESC

不行，还是有重复…… 怎么办呢？
我是用ASP+SQL SERVER

[rengang11]

SORRY,刚才写错了,利用子查询

SELECT distinct(u.NetName)，distinct(u.UserName) FROM diaryUser u INNER JOIN diaryData d ON d.UserID=u.UserID ORDER BY d.DiaryID DESC
WHERE u.NetName IN

SELECT TOP 10 distinct(u.NetName)，distinct(u.UserName) FROM diaryUser

[rengang11]

SELECT TOP 10 distinct(u.NetName)，distinct(u.UserName) FROM diaryUser u INNER JOIN diaryData d ON d.UserID=u.UserID ORDER BY d.DiaryID DESC

[CMIC]

SELECT distinct TOP 10 u.NetName，u.UserName FROM diaryUser u INNER JOIN diaryData d ON d.UserID=u.UserID ORDER BY d.DiaryID DESC

[ern]

楼主不知道distinct?呵呵，去看看sql的东西吧

[ckxp]

rengang11(rhg) 的语法不对，不能用在这里，以前就试过
Microsoft OLE DB Provider for SQL Server 错误 '80040e14'

在关键字 'distinct' 附近有语法错误。


CMIC(大象) 这个也试过，查询结果还是有重复，怎么办啊？