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 vote152 views1 answer
Mysql select top 2
SQL
0 vote191 views1 answer
Start and stop mysql
SQL
0 vote182 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote190 views1 answer
Raven ql select count
SQL
0 vote207 views1 answer
Oracle insert single quote in string
SQL
0 vote196 views1 answer
How to add boolean column in postgresql
SQL
0 vote185 views1 answer
Postgres call view
SQL
0 vote197 views1 answer
Sql server datetime
SQL
1 vote206 views1 answer
Regular expression in sql server
SQL
2 votes196 views3 answers
Current month mysql query
SQL