举例
id c vid
=============
1 abc 2
2 hug 2
3 uuu 4
4 iji 8
.. ... ...
SELECT TOP 10 * FROM [ 表 ] ORDER BY [id] DESC现在选择的时候,不想在选择出来的记录中存在相同的vid,即没有重复的vid,应该怎么改写这个语句?
id c vid
=============
1 abc 2
2 hug 2
3 uuu 4
4 iji 8
.. ... ...
SELECT TOP 10 * FROM [ 表 ] ORDER BY [id] DESC现在选择的时候,不想在选择出来的记录中存在相同的vid,即没有重复的vid,应该怎么改写这个语句?
where id in (select top 10 max(id) from 表 group by vid)
ORDER BY [id] DESC
关键字 'distinct' 附近有语法错误。
=======================================select * from [View_VideoComments] where vid in (select top 10 vid from (select distinct vid from [View_VideoComments]) t)结果显示是全部的数据,包括vid有重复的项。
=========================================
SELECT * FROM [View_VideoComments]
where cid in (select top 10 max(cid) from [View_VideoComments] group by vid)
ORDER BY [vid] DESC可以运行。达到效果。
===========================================谢谢楼上2位。