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 vote145 views1 answer
Oracle right characters
SQL
0 vote138 views1 answer
Heavy table in mysql
SQL
-1 vote176 views1 answer
Search all sql tables for a value
SQL
2 votes141 views1 answer
Find all triggers in database
SQL
1 vote152 views2 answers
Procedure syntax
SQL
0 vote159 views1 answer
Renommer base sql
SQL
50 votes215 views4 answers
Sql alter type of column
SQL
0 vote137 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote135 views2 answers
Postgresql change user role grant
SQL
0 vote141 views1 answer
Create table sql generator
SQL