一句不算太难的sql语句，麻烦了。
有两个表 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)
