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 vote202 views2 answers
Plsql regex match whole word
SQL
19 votes203 views6 answers
Laravel sql query
SQL
0 vote280 views1 answer
Opensuse start MySQL
SQL
2 votes239 views1 answer
Sql get the name of user pc
SQL
0 vote204 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote200 views1 answer
Create function syntax sql server
SQL
1 vote221 views1 answer
Lpad function in sql oracle
SQL
1 vote274 views2 answers
Intersect sql
SQL
0 vote190 views1 answer
Find usage of table in sql server
SQL
1 vote205 views2 answers
How to check if sql query is correct online
SQL