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 vote186 views1 answer
Tsql random number
SQL
1 vote156 views1 answer
Oracle rolling back
SQL
0 vote167 views1 answer
Oracle dynamic select into
SQL
1 vote169 views2 answers
How to enable error squiggles in vs code
SQL
0 vote167 views1 answer
Postgres declare variable
SQL
0 vote177 views3 answers
Fetlife
SQL
2 votes188 views1 answer
Pandas to sql index
SQL
0 vote200 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote162 views1 answer
Mysql convert charset
SQL
1 vote141 views2 answers
Get date from datetime postgresql
SQL