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

1 vote122 views1 answer
Sql server list locks
SQL
1 vote114 views1 answer
ORA-01950
SQL
4 votes118 views1 answer
Oracle user tables
SQL
2 votes119 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote116 views1 answer
Sql select upcoming birthdays
SQL
0 vote128 views1 answer
Mysql remove bad character from all fields
SQL
0 vote110 views1 answer
Oracle last connection
SQL
4 votes118 views2 answers
Tables in sql
SQL
0 vote115 views1 answer
Mariadb errno 121
SQL
3 votes119 views1 answer
Make a field auto_increment mysql
SQL