博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::
SELECT * FROM ( SELECT TOP 20 ppab_account,ppab_payee_ai_id, 
       (CASE WHEN (ppab_payee_ai_id!=0 OR ppab_payee_ai_id is NOT NULL) THEN 
       ( SELECT TOP 1 ai_cnname FROM account_info WHERE ai_id=ppab_payee_ai_id )
       ELSE '''' END ) AS ai_cnname,
       COUNT(ppab_account) AS 'ppab_count' ,SUM(ppab_amount) AS 'ppab_amount',
       ROW_NUMBER() OVER( ORDER BY COUNT(ppab_account) DESC    ) AS RowNo
       FROM dbo.PAY_POS_ACCOUNT_BLL WHERE ppab_account is NOT null
       GROUP BY ppab_account,ppab_payee_ai_id) AS A     WHERE RowNo>10  

 

posted on 2013-03-15 11:20    阅读(660)  评论(0)    收藏  举报