Sql rank

-- Employees per department, ranked in salary order
SELECT EMPNO,
       DEPTNO,
       SAL,
       rank() OVER (PARTITION BY DEPTNO ORDER BY SAL) AS MYRANK
FROM EMP;

Source: oracle-base.com

How to use rank function in sql

BY LOVE SINGH,
Here, name and id is the column name of the table tbltest.

SELECT
	name,
	RANK () OVER ( 
		ORDER BY id DESC
	) price_rank 
FROM
	tbltest;

Similar codes

1 vote126 views1 answer
Pl sql create table from another table
SQL
0 vote127 views3 answers
Sql select statements
SQL
0 vote145 views1 answer
Get create sql of hibernqte entity
SQL
3 votes132 views2 answers
Order by postgresql
SQL
0 vote125 views1 answer
2020 new year
SQL
0 vote213 views3 answers
Insert or ignore postgres
SQL
1 vote140 views1 answer
Where to locate set password for mysql
SQL
0 vote133 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote129 views1 answer
Calculate age in sql
SQL
0 vote156 views1 answer
Sqlite3 pragma foreign keys
SQL