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

17 votes361 views4 answers
Postgres list users
SQL
0 vote375 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
4 votes355 views2 answers
Mysql how to change default charset
SQL
2 votes370 views1 answer
Sqlplus clear screen
SQL
0 vote421 views1 answer
Mysql convert charset
SQL
0 vote357 views1 answer
Psql list rules
SQL
1 vote384 views2 answers
Mysql add column tinyint default 0
SQL
0 vote394 views1 answer
How to get button for every record from mysql
SQL
0 vote420 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote334 views2 answers
Find Overlapping sql
SQL