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

1 vote137 views1 answer
Pl sql ptint
SQL
0 vote158 views1 answer
What is common table expression in sql
SQL
0 vote161 views1 answer
Time in sql server
SQL
-1 vote154 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote140 views1 answer
Mysql count unique in group statement
SQL
0 vote129 views2 answers
How to get json data mysql
SQL
1 vote170 views1 answer
Postgresql if 0 then 1
SQL
0 vote132 views1 answer
Como saber si tengo mysql instalado
SQL
2 votes136 views1 answer
Find all triggers in database
SQL
3 votes150 views1 answer
Oracle undo tablespace schema
SQL