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

11 votes349 views2 answers
Oracle all source
SQL
0 vote356 views1 answer
Sql select inside select sub query
SQL
1 vote374 views3 answers
What is union in sql
SQL
1 vote378 views1 answer
Oracle previous year
SQL
51 votes601 views6 answers
Opera gx
SQL
0 vote356 views1 answer
Plsql check for string in numeric
SQL
4 votes350 views2 answers
Mysql select where starts with
SQL
0 vote362 views1 answer
T sql check active deadlock
SQL
2 votes359 views1 answer
How to insert string variable into sqlite database
SQL
0 vote363 views1 answer
Narural join
SQL