有两个表 member和info
info表中有membeid和member关联。
会员可以发布信息到info表， 现在怎么能得到最新的10个发布了信息的会员名称membername，并且不重复？
我是这样写的，select membername from member where memberid in(select top 10 distinct memberid from info order by infoid desc) 但是报错了。
top 和 distinct该怎么用？
------解决方案--------------------------------------------------------
select distinct top 10 memberid from info order by infoid desc
------解决方案--------------------------------------------------------
select top 10 distinct 写反了
------解决方案--------------------------------------------------------
select membername from member where memberid in(select top 10 distinct memberid,infoid from info order by infoid desc
------解决方案--------------------------------------------------------
這樣呢？
select membername from member where memberid in(select distinct top 10 memberid from info order by infoid desc)
------解决方案--------------------------------------------------------
帮定
------解决方案--------------------------------------------------------
select membername from member where memberid in(select top 10 memberid,max(infoid) as newid from info group by memberid order by newid desc)
------解决方案--------------------------------------------------------
try
select membername from member where memberid in(select top 10 memberid from info Group By memberid order by Max(infoid) desc)