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 vote149 views1 answer
Psql lst trigger
SQL
0 vote152 views1 answer
Oracle grant create job
SQL
2 votes138 views1 answer
Ssh mysql port forwarding
SQL
1 vote238 views1 answer
Truncate table in postgresql and reset id
SQL
1 vote139 views1 answer
Can not connect to mysql server
SQL
0 vote157 views1 answer
Install sql server windows 10
SQL
2 votes157 views1 answer
Add new column not null sql server
SQL
4 votes145 views1 answer
Update table from another table oracle
SQL
0 vote142 views1 answer
What is between operator
SQL
0 vote163 views1 answer
How to create a table in sql stack overflow
SQL