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 vote127 views2 answers
How to get last inserted id in sql server c#
SQL
3 votes79 views1 answer
Postgresql where current year
SQL
0 vote117 views1 answer
Drop tables from local database postgres pgadmin
SQL
1 vote121 views1 answer
Convert to hexadecimal sql
SQL
1 vote121 views1 answer
SQL date part only of datetime
SQL
0 vote122 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote115 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote116 views1 answer
Database timezone
SQL
0 vote82 views2 answers
Postgresql could not start server mac
SQL
10 votes113 views3 answers
Sql limit results
SQL