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 views1 answer
Reset postgres table index to next max value
SQL
0 vote342 views1 answer
Select top values sql
SQL
0 vote353 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
1 vote333 views1 answer
Postgresql export output table as a csv
SQL
4 votes386 views4 answers
Check constraint in ms sql
SQL
-1 vote348 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote354 views1 answer
Create table split string function in sql server
SQL
0 vote320 views2 answers
Close external port 3306 with iptables
SQL
0 vote285 views2 answers
Influxdb delete measurement based on date
SQL
0 vote334 views1 answer
Oracle create job if not exists
SQL