![ContractedBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![ExpandedBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
select top 10 * from T_activity A where not exists(select resourceId from T_activity where memberid=A.memberid
and AuthorId=A.AuthorId and activitytime>A.activitytime) order by activitytime desc
转载于:https://www.cnblogs.com/phw0921/archive/2009/11/06/1597498.html