银行数据查询SQL技巧一(多层嵌套子查询相同字段保留技巧)

彻底解决办法

在最初层用AS重新定义字段名

SELECT * 
FROM
 (select *
from
 (select *,row_number() over (partition by 字段a1  )  AS num
    FROM
     (select 字段a AS 字段a1 ,字段b AS 字段b1，count(*) as 笔数 ,SUM(字段c)/1000000 as 金额
      from 
     表a
      WHERE 条件a
      group by 字段a,字段b)  )
 where num<3) AS A INNER  JOIN  
 (SELECT * 
 FROM
 表a
      WHERE 条件a) AS B
WHERE A.字段a1=B.字段a AND A.字段b1=B.字段b