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 vote243 views1 answer
Sql server read uncommitted
SQL
11 votes169 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote156 views1 answer
How to search query in python3 sqlite3
SQL
1 vote180 views1 answer
Sql row having max
SQL
2 votes172 views4 answers
Mysql get all tables row count
SQL
7 votes186 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote124 views1 answer
Select all domains of database firbird
SQL
1 vote161 views1 answer
How to update date add hours in postgresql
SQL
0 vote186 views1 answer
Like date sql server not working
SQL
37 votes210 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL