declare @AA int,@BB int
select @AA = usercode from user order by usercode
select @bb = usercode from user order by usercode desc
while @bb <@AA
begin
select top 10 * from content where usercode = @bb group by usercode,title,content.id order by usercode, content.id desc
set @bb = @bb+1
end
不知是否是這樣兩個表:User(userid,usercode),Content(usercode,title,id)
如果是:
select a.userid, top 10 b.usercode,b.title,b.id
from user a left join content b on a.usercode = b.usercode
order by b.id desc