select top 10 username from userInfo as a inner join tiezi as b on a.id = b.userid group by b.userid仅供参考
select top 10 userid from(select distinct(userid) from tiezi order by fatieshijian desc)
select top 10 NickName from userinfo where id in(select distinct(userid) from tiezi order by fatieshijian desc)
select 昵称 from 用户表 where id in( select distinct(userid) from tiezi order by fatieshijian desc)
select top 10 NickName from userinfo where id in(select distinct(userid) from tiezi order by createtime 除非同时指定了 TOP,否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。 这个是什么问题?
select top 10 NickName from userinfo where id in(select distinct(userid) from tiezi order by fatieshijian desc)除非同时指定了 TOP,否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。
select NickName from userinfo where id in (select top 10 userid from (select userid,max(发帖时间) as tt from tiezi group by userid)as T order by T.tt desc)
a.id = b.userid
group by b.userid仅供参考
select top 10 userid from(select distinct(userid) from tiezi order by fatieshijian desc)
from userinfo
where
id in
(select top 10 userid from
(select userid,max(发帖时间) as tt from tiezi group by userid)as T
order by T.tt desc)