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

3 votes186 views1 answer
Query less than datetime sql
SQL
0 vote145 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote143 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote136 views1 answer
Like sql for second letter of the family name
SQL
0 vote152 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
1 vote184 views2 answers
Laravel jwt generate token
SQL
6 votes143 views1 answer
Sqlite foreign key
SQL
0 vote136 views1 answer
User defined variables in sql
SQL
21 votes138 views1 answer
SQL cheat sheet pdf
SQL
1 vote141 views1 answer
Oracle stop job
SQL