我有两个表: (1)Dv_user (2)Bu_wenziindex userid int; id int; username nvarvhar(50); username nvarchar(50); num int userid int num是计算表2中每个username的发帖数量,我现在想显示每个不同用户提交的 最后1条数据,并将最后10位用户的username显示出来.
试一下,没测试,大致是这个思路吧
所有用户的不重贴子
SELECT wenziid,wenzititle,wenziaddress,wenzidate,username,userid FROM Bu_wenziindex INNER JOIN (SELECT DISTINCT(username) AS dist_name,MAX(wenzidate) AS max_time FROM Bu_wenziindex GROUP BY username) AS seartable ON seartable.dist_name = Bu_wenziindex.username AND seartable.max_time = Bu_wenziindex.wenzidate
sql="select id from bu_wenziindex where id in (select top 1 a.id from bu_wenziindex as a where a.id=b.id order by id desc)"
这个SQL通不过吧 order by id desc 能放里面吗?