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 vote160 views1 answer
Database run
SQL
-1 vote196 views1 answer
Auto increment psql not primary key
SQL
0 vote243 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote246 views1 answer
Import sql inside hide sql
SQL
-1 vote200 views1 answer
Ssql to lowercqse
SQL
0 vote214 views1 answer
Postegresql update to null
SQL
0 vote204 views1 answer
Rename constraint postgresql
SQL
5 votes201 views2 answers
Postgres update with if condition query
SQL
1 vote236 views1 answer
Delete mysql ubuntu 20.04
SQL
2 votes198 views1 answer
Date_format for time sql
SQL