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

2 votes282 views1 answer
Convert series number to date in sql
SQL
0 vote383 views1 answer
Redshift running queries
SQL
5 votes297 views2 answers
Oracle show procedures
SQL
2 votes295 views1 answer
Apex date today add days
SQL
0 vote319 views1 answer
Mysql extract day from date leading zero
SQL
3 votes324 views1 answer
Laravel database Using Named Bindings
SQL
0 vote274 views1 answer
Postgres create database if not exists
SQL
3 votes271 views1 answer
If 0 return null else return query mysql
SQL
0 vote305 views1 answer
How to export only procedures mysql
SQL
5 votes326 views3 answers
Postgres show databases
SQL