Sql row number in result set

SELECT 
    ROW_NUMBER() OVER (
            ORDER BY salary
    ) row_num, 
    first_name, 
    last_name, 
    salary
FROM
    employees;
Code language: SQL (Structured Query Language) (sql)

Source: sqltutorial.org

Similar codes

5 votes357 views1 answer
Commentaire table oracle
SQL
10 votes389 views1 answer
Oracle view dependencies
SQL
8 votes362 views1 answer
Oracle add months to sysdate
SQL
-1 vote365 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
6 votes361 views1 answer
Oracle list primary key
SQL
0 vote378 views1 answer
Sql menampilkan data tabel
SQL
1 vote360 views1 answer
How to use a trigger to validate input data
SQL
0 vote394 views1 answer
Select the date 30 days less that the todays date sql request
SQL
17 votes387 views4 answers
Show tables sql server
SQL
1 vote370 views1 answer
How to see which columns are indexxed mysql
SQL