如何在select语句中生成序列号+加1 [英] how to generate Serial numbers +Add 1 in select statement
问题描述
我知道我们可以在 select 语句中生成 row_number.但是 row_number 从 1 开始,我需要从 2 开始生成.
I know we can generate row_number in select statement. But row_number starts from 1, I need to generate from 2 and onwards.
示例
party_code
----------
R06048
R06600
R06791
(3 row(s) affected)
I want it like
party_code serial number
---------- -------------
R06048 2
R06600 3
R06791 4
目前我正在使用下面的 select 语句来生成常规行号.
Current I am using below select statement for generate regular row number.
SELECT party_code, ROW_NUMBER() OVER (ORDER BY party_code) AS [serial number]
FROM myTable
ORDER BY party_code
如何修改上面的select语句并从2开始?
How can modify above select statement and start from 2?
推荐答案
SELECT party_code, 1 + ROW_NUMBER() OVER (ORDER BY party_code) AS [serial number]
FROM myTable
ORDER BY party_code
补充:ROW_NUMBER()
有一个不寻常的语法,可能会与各种 OVER
和 PARTITION BY
子句混淆,但是当总而言之,它仍然只是一个带有数字返回值的函数,并且可以像操作任何其他数字一样操作该返回值.
to add: ROW_NUMBER()
has an unusual syntax, and can be confusing with the various OVER
and PARTITION BY
clauses, but when all is said and done it is still just a function with a numeric return value, and that return value can be manipulated in the same way as any other number.
这篇关于如何在select语句中生成序列号+加1的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!