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

2 votes117 views3 answers
Application.properties spring boot mysql
SQL
1 vote144 views1 answer
Size of all tables in a schema oracle
SQL
0 vote104 views1 answer
Mysqlcli how to load external sql file
SQL
3 votes124 views2 answers
Oracle drop sequence
SQL
1 vote116 views1 answer
Psql import backup file for windows
SQL
0 vote128 views10 answers
John the ripper mysql
SQL
-1 vote117 views1 answer
Module operator in oracle sql
SQL
7 votes110 views1 answer
Buy forge mods server hosting
SQL
0 vote103 views1 answer
Mysql add to value
SQL
0 vote107 views1 answer
Mysql join same table multiple times group by
SQL