MSSQL 无标识列 无主键 group by row_number() over() 分页

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  
原文地址:https://www.cnblogs.com/szfhquan/p/2961016.html