【SELECT 分类TOP N 的问题】
摘要：
查询一个数据表中,每个不同类别的TOP N的方法.
Select A.* From #t3 A
Inner Join (select distinct prj_id from #t3) as B
On A.prj_id=B.prj_id
Where (Select Count(*) From #t3 Where prj_id=A.prj_id And amountA.amount)10 阅读全文
posted @ 2008-06-26 15:21 155144 阅读(307) 评论(0) 推荐(0) 编辑