28,390
社区成员
发帖
与我相关
我的任务
分享
select uname, max(nid) from news
inner join user on user.uid = news.ssid
group by uname
order by max(nid)
select top 10 uid,uname from user where uid in (select distinct ssid from news order by ssid desc)
select u.*
from user u inner join (
select top 10 ssid,max(nid)
from news
group by ssid
order by 2) b on u.uid=b.ssid