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 vote285 views1 answer
Import sql in postgresql
SQL
0 vote294 views2 answers
Homebrew nysql launch
SQL
1 vote292 views1 answer
Mysql select for update ejemplo
SQL
1 vote233 views1 answer
Strict in postgres SQL
SQL
1 vote278 views1 answer
Oracle finding duplicate records
SQL
1 vote267 views1 answer
Oracle first row
SQL
0 vote263 views1 answer
Pl sql search saurce code
SQL
0 vote262 views1 answer
Sql select non unique
SQL
0 vote228 views1 answer
Update sql join multiple tables
SQL
1 vote254 views1 answer
Delete triger pl pg sql
SQL