SQL如何将整数添加到行号

Question

大家好，我希望你们能在下面的代码中帮助我返回一个行号加1的列，

with max_num as (..)
select 
a.load,
a.id,
CAST(ROW_NUMBER() over(order by a.id desc) AS INT) numbe,
sum(numbe + 1) as nmbe2
from max_num a
group by a.load
, a.id        
order by  a.id

Answer 1

您可以这样做：

select a.load,
a.id,
ROW_NUMBER() over(order by a.id desc) rn,
ROW_NUMBER() over(order by a.id desc)+1 rn_plus_1
from max_num a
group by a.load, a.id
order by a.load, a.id;

演示

但你必须给我们更多关于你想做什么的信息…