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 vote188 views2 answers
Check if word is in column sql
SQL
-1 vote178 views3 answers
Create temp table in sql
SQL
38 votes258 views4 answers
Count sql
SQL
0 vote231 views1 answer
Selecting from a view SQL
SQL
0 vote192 views1 answer
Insert into Select * - NAYCode.com
SQL
1 vote167 views1 answer
Using SQL in rails migration
SQL
1 vote181 views1 answer
Sql server list locks
SQL
1 vote329 views1 answer
Mysql data from file
SQL
0 vote191 views1 answer
Sql server union if table exist
SQL
3 votes205 views3 answers
Create table in microsoft sql server
SQL