Tsql row number

SELECT 
   ROW_NUMBER() OVER (
 ORDER BY first_name
   ) row_num,
   first_name, 
   last_name, 
   city
FROM 
   sales.customers;

Source: sqlservertutorial.net

Row number mssql

        
            
        
     SELECT 
   ROW_NUMBER() OVER (
	ORDER BY first_name
   ) row_num,
   first_name, 
   last_name, 
   city
FROM 
   sales.customers;

Source: sqlservertutorial.net

Similar codes

18 votes134 views6 answers
Drop table if exists
SQL
2 votes150 views1 answer
Postgresql transaction
SQL
9 votes138 views4 answers
How to alter table column name in mysql
SQL
0 vote135 views1 answer
Sql developer connect to sql server
SQL
1 vote146 views1 answer
How to show index type in postgresql
SQL
0 vote149 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote126 views1 answer
Sql remove last x char
SQL
0 vote143 views1 answer
Intellij idea add mysql connector
SQL
0 vote128 views1 answer
Mysql undo delete
SQL
0 vote142 views1 answer
Select nth row in mysql
SQL