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

8 votes277 views1 answer
Oracle search text in all packages
SQL
0 vote270 views1 answer
Oracle date winter time
SQL
0 vote260 views1 answer
Sql select most frequent value in column
SQL
3 votes247 views1 answer
Oracle rollback
SQL
0 vote297 views1 answer
Sql select without column name
SQL
0 vote254 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote248 views1 answer
Sqlite closes value
SQL
3 votes288 views5 answers
No module named 'MySQLdb'
SQL
1 vote256 views1 answer
Oracle avg
SQL
4 votes208 views3 answers
Create table if not exists postgresql
SQL