Use the row_number () over function to assign line numbers to each record in the SQL database _mssql

Starting with SQL Server 2005, adding a new function row_number (), one of his great role is that you can add a column in the datasheet from the beginning of the 1 line number, which greatly replaces all the extra code to produce line numbers. Let's teach you how to use the Row_number () function.

Suppose the database has the following table:

Copy Code code as follows:

ID Name
1 AA
3 BB
4 cc

After executing the following SQL statement, you will get the following result:

SELECT row_number () over (order by ID) as rownum,* from table name

Copy Code code as follows:

RowNum ID Name
1 1 AA
2 3 BB
3 4 cc