--try
select * from 表 a
where uesrid in (select top 10 * from 表 where userid=a.userid and ctid=b.ctid )
select * from 表 a
where uesrid in (select top 10 * from 表 where userid=a.userid and ctid=b.ctid )
调试欢乐多
where ctid in (select top 10 ctid
from 表
where userid=t.userid
order by ctid)
where uesrid in (select top 10 userid from 表 where userid=a.userid)
where content in (select top 10 content from 表 where userid=a.userid)
我简单试了以下还可以。