SELECT [linksitename],[linkidname], [lid], [linksh], [ldate],[linksite] FROM [t8_link] a where not exists(select top 1 * from [t8_link] where linksitename=a.linksitename) ORDER BY [ldate] DESC
最好贴几个数据出来可以帮你测试好,否则只能粗略的:SelectCommand="SELECT [linksitename],[linkidname], [lid], [linksh], [ldate],[linksite] FROM [t8_link] T WHERE NOT EXISTS (SELECT 1 FROM [t8_link] WHERE linksitename =T.linksitename AND [lid]<T.[lid]) ORDER BY [ldate] DESC"
SELECT distinct [linksitename],[linkidname], [lid], [linksh], [ldate],[linksite] FROM [t8_link] ORDER BY [ldate] DESC 这样的结果是[linksitename],[linkidname], [lid], [linksh], [ldate],[linksite] 不会重复的,但有可能linksitename重复,而其他字段不通的。
try:SELECT [linksitename],[linkidname], [lid], [linksh], [ldate],[linksite] FROM [t8_link] t WHERE NOT EXISTS(SELECT 1 FROM [t8_link] WHERE [linksitename]=t.[linksitename] and [ldate]>t.[ldate]) ORDER BY [ldate] DESC
相同linksitename的取ldate最大的 SELECT [linksitename], [linkidname], [lid], [linksh], [ldate], [linksite] FROM [t8_link] t WHERE not exists(select 1 from [t8_link] where [linksitename]=t.[linksitename] and [ldate]>t.[ldate])
这样的结果是[linksitename],[linkidname], [lid], [linksh], [ldate],[linksite] 不会重复的,但有可能linksitename重复,而其他字段不通的。
[linksitename],[linkidname], [lid], [linksh], [ldate],[linksite]
FROM
[t8_link] t
WHERE
NOT EXISTS(SELECT 1 FROM [t8_link] WHERE [linksitename]=t.[linksitename] and [ldate]>t.[ldate])
ORDER BY
[ldate] DESC
SELECT
[linksitename],
[linkidname],
[lid],
[linksh],
[ldate],
[linksite]
FROM
[t8_link] t
WHERE
not exists(select 1 from [t8_link] where [linksitename]=t.[linksitename] and [ldate]>t.[ldate])
htl258
的答案正确
。结贴给分josy 好的思路。虽然在我这不能这么用