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 vote334 views1 answer
Recursive query herarchical data sql server
SQL
22 votes353 views3 answers
Join three tables sql
SQL
0 vote348 views1 answer
Add multiple field in table sql
SQL
1 vote410 views1 answer
Insert pg result of select
SQL
0 vote398 views2 answers
Mysql show foreign keys
SQL
14 votes345 views3 answers
SQL trim
SQL
0 vote379 views1 answer
Sqlite woth cmake
SQL
1 vote308 views1 answer
Alter user mysql native password
SQL
1 vote377 views1 answer
Mysql search like order by best match
SQL
0 vote374 views1 answer
Insert data from stored procedure into table
SQL