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 votes213 views2 answers
Union all in sql
SQL
0 vote233 views1 answer
Sqlcl format
SQL
0 vote200 views1 answer
Pip install mysqlclient error
SQL
24 votes209 views4 answers
Mssql get all table names
SQL
0 vote197 views1 answer
Postgres enumerated type
SQL
3 votes208 views2 answers
Oracle for loop
SQL
1 vote201 views1 answer
Group_concat max length mysql
SQL
0 vote201 views1 answer
Possgress drop if exists view
SQL
0 vote213 views1 answer
How to write if case in select query in select statement
SQL
3 votes215 views2 answers
Sql get month name
SQL