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

3 votes182 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
4 votes183 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
1 vote183 views1 answer
Oracle update with sequence
SQL
8 votes193 views3 answers
Postgres database sizes
SQL
24 votes172 views2 answers
Alter table delete column
SQL
0 vote178 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
1 vote202 views2 answers
Mysql switch case
SQL
10 votes189 views4 answers
How to alter table name in mysql
SQL
2 votes175 views1 answer
How to check grants on a package in oracle
SQL
23 votes198 views4 answers
How to show all users in mysql
SQL