select 分辨率, sum(新增用户), sum(活跃用户), sum(启动次数) from table group by 分辨率 order by sum(新增用户)
我来说下,我遇到的问题吧。。 select * from ( select ROW_NUMBER()over( order by (新增用户)) as rowIndex, 分辨率 as 分辨率, --分辨率 Sum(新增用户) as 新增用户, --新用户 Sum(新增用户) as 新增用户, --启动次数 Sum(活跃用户) as 活跃用户 --活跃用户 from Table1 Group By DeviceResolution ) WHERE rowIndex>1 AND rowIndex<20这么写的话,就会提示新增用户不在Group By语句后
这样的话,row_number()over (order by XX)怎么写呢?
其实很多种方法的 Select * From ( select 分辨率, sum(新增用户) as [新增用户], sum(活跃用户) as [活跃用户], sum(启动次数) as [启动次数] from table group by 分辨率 ) tb ORder by [新增用户]
select 分辨率, sum(新增用户), sum(活跃用户), sum(启动次数)
from table
group by 分辨率
order by sum(新增用户)
(
select
ROW_NUMBER()over( order by (新增用户)) as rowIndex,
分辨率 as 分辨率, --分辨率
Sum(新增用户) as 新增用户, --新用户
Sum(新增用户) as 新增用户, --启动次数
Sum(活跃用户) as 活跃用户 --活跃用户
from
Table1
Group By DeviceResolution
)
WHERE rowIndex>1 AND rowIndex<20这么写的话,就会提示新增用户不在Group By语句后
Select * From
(
select 分辨率, sum(新增用户) as [新增用户], sum(活跃用户) as [活跃用户], sum(启动次数) as [启动次数]
from table
group by 分辨率
) tb ORder by [新增用户]