如图左表是原表，有三列dim，计算面积要用到最大尺寸乘以第二大尺寸，如何写语句得到右图表格。谢谢。
select name,sum(case when RN=1 then dim else 0 end ) 最大尺寸,
sum(case when RN=2 then dim else 0 end ) 第二大尺寸
from (
select
name
,row_number()over (partition by name order by dim desc) RN
,dim
select name ,dim1 dim from table
union all
select name ,dim2 dim from table
select name ,dim3 dim from table)
)
group by name
1min目标场景问卷
立即参与
