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 vote196 views1 answer
Oracle activate job
SQL
3 votes295 views1 answer
Ssh check mysql version
SQL
0 vote162 views1 answer
Hibernate xml property MySQL url, username and password
SQL
1 vote194 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote173 views1 answer
Match end of string regex sql
SQL
1 vote175 views1 answer
Create temporal table in sql
SQL
0 vote166 views1 answer
Mysql disable query caching
SQL
2 votes216 views1 answer
Show max_allowed_packet mysql
SQL
1 vote350 views1 answer
Postgres convert text to number
SQL
4 votes177 views1 answer
Oracle show errors
SQL