traveller86_的博客

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

(select 字段a AS 字段a1 ,字段b AS 字段b1，count(*) as 笔数 ,SUM(字段c)/1000000 as 金额。(select *,row_number() over (partition by 字段a1 ) AS num。WHERE A.字段a1=B.字段a AND A.字段b1=B.字段b。group by 字段a,字段b) )WHERE 条件a) AS B。在最初层用AS重新定义字段名。