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 vote236 views1 answer
Sql select first and last record of each group
SQL
0 vote171 views1 answer
Running query in redshift
SQL
2 votes201 views3 answers
Sql interview query questions
SQL
0 vote194 views1 answer
Mariadb maximum left join
SQL
0 vote179 views1 answer
Execut sql python
SQL
20 votes228 views4 answers
How to find average in sql
SQL
7 votes191 views5 answers
Oracle alter table
SQL
0 vote190 views1 answer
Java check if something is in mysql table
SQL
0 vote173 views1 answer
The local psql command could not be located
SQL
18 votes188 views3 answers
Find column name in database
SQL