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 vote209 views1 answer
How to output a different column name in mysql
SQL
0 vote203 views1 answer
Sum sqlserver
SQL
37 votes290 views6 answers
Mysql update
SQL
0 vote221 views1 answer
Oracle gather table statistics
SQL
5 votes223 views1 answer
Find table from column name in sql
SQL
0 vote227 views1 answer
T-SQL Create Trigger
SQL
0 vote205 views1 answer
Show function mysql
SQL
0 vote216 views1 answer
Database xml sql
SQL
57 votes364 views5 answers
How to create a new user in postgresql
SQL
1 vote222 views1 answer
Get last week data in mysql
SQL