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

0 vote147 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote124 views1 answer
Mysql command line ubuntu
SQL
11 votes118 views2 answers
Insert date sql
SQL
0 vote141 views1 answer
Query for backup a database at another location in file system
SQL
0 vote142 views1 answer
Create a plsql object
SQL
0 vote125 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote133 views1 answer
Oracle sql drop table
SQL
0 vote149 views1 answer
Space not removing from column in sql
SQL
0 vote134 views1 answer
Sql reverse order of results
SQL
0 vote156 views2 answers
Getting customers with no orders sql
SQL