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 vote137 views1 answer
Sql query to select records entered in last 24 hours
SQL
2 votes169 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote161 views1 answer
Sort by last two number sql
SQL
0 vote135 views1 answer
Sub blocks in sql
SQL
0 vote150 views1 answer
Conda install pymysql "windows"
SQL
0 vote142 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote142 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote140 views1 answer
Create new table pl sql
SQL
7 votes158 views1 answer
Mysql remote connection command line
SQL
21 votes152 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL