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 vote189 views3 answers
Divide by zero error in sql
SQL
1 vote160 views1 answer
How to get alternate records from a table in sql
SQL
-1 vote193 views1 answer
How to Activate the database
SQL
-1 vote184 views1 answer
Pl sql drop trigger
SQL
0 vote210 views1 answer
How to compile a function in oracle
SQL
0 vote189 views2 answers
Mysql where in maintain order group_concat
SQL
6 votes168 views2 answers
Mysql get yesterday
SQL
4 votes160 views2 answers
Mysql how to change default charset
SQL
0 vote166 views1 answer
Mod in sql
SQL
6 votes192 views6 answers
Rename column postgres
SQL