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

0 vote354 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote312 views1 answer
RowDataPacket
SQL
0 vote346 views1 answer
Get statis values sql
SQL
0 vote310 views1 answer
Postgres data location
SQL
1 vote305 views1 answer
Mysql count words
SQL
0 vote333 views1 answer
Postgres regex word boundary
SQL
0 vote307 views1 answer
We are intrested to work with your organization
SQL
2 votes318 views2 answers
How to check data type in sql server
SQL
2 votes305 views1 answer
Drop table if exists in postgres
SQL
7 votes320 views1 answer
Alter sequence set current value oracle
SQL