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

5 votes237 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
12 votes264 views1 answer
Run mysql instance in docker
SQL
0 vote275 views1 answer
Sql to search who modified
SQL
0 vote243 views1 answer
Get who is hired in month in sql
SQL
0 vote229 views1 answer
Number(10 2) in sql means
SQL
1 vote238 views1 answer
Best sql course
SQL
1 vote245 views1 answer
Get last week data in mysql
SQL
0 vote234 views1 answer
Psql select * from table
SQL
0 vote236 views1 answer
Recover deleted data from mysql database
SQL
0 vote259 views1 answer
Python mysql show databases
SQL