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

0 vote131 views1 answer
Install mysql for fedora 34
SQL
11 votes128 views1 answer
Oracle insert into where
SQL
2 votes132 views1 answer
Match in sql server
SQL
0 vote131 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote200 views1 answer
Import sql dump into postgresql database
SQL
0 vote154 views2 answers
How to get the date from datetime in mysql
SQL
1 vote93 views1 answer
Pagination sql
SQL
0 vote126 views1 answer
Oracle DROP PROGRAM
SQL
10 votes141 views2 answers
Mysql alter add foreign key
SQL
0 vote91 views1 answer
Update row in sqlite python
SQL