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

1 vote187 views1 answer
Md5 encryption for existing records
SQL
1 vote182 views1 answer
Mysql select utc time in eastern time
SQL
0 vote194 views1 answer
Drop view in mysql
SQL
0 vote192 views1 answer
What is mysql_pconnect
SQL
0 vote188 views2 answers
Oracle sql for each row
SQL
3 votes186 views1 answer
How to find names includes in sql
SQL
9 votes203 views3 answers
Mysql run sql file
SQL
14 votes219 views6 answers
Finding duplicate rows mysql
SQL
0 vote241 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
1 vote247 views1 answer
Oracle apex version view
SQL