select row_number() over(order by (je/累计) desc) as 排名,PRODUCTNAME,je,je/累计 as 占比,累加/累计 as 累计占比 from ( select PRODUCTNAME,je,sum(je) over() as 累计,sum(je) over(order by je) as 累加 from(select PRODUCTNAME,sum(SALE_AMOUNT*PRICE) as je from sql2002_01 inner join sql2002_03 on sql2002_01.PRODUCTID=sql2002_03.PRODUCTID group by PRODUCTNAME ) t ) tt where 累加/累计>0.8; |
1min目标场景问卷
立即参与
