Ranking functions in sql

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;

Ranking functions in sql

ROW_NUMBER() -- 1,2,3,4,5 (different rank no. to same value)
RANK() --  1,2,2,4,5 (same rank no. to same value but next rank is skipped)
DENSE_RANK() --  1,2,2,3,4 (same rank no. to same value but no skip in rank no.)

RANKING FUNCTION NAME() OVER([PARTITION BY <COLUMN NAME>] ORDER BY
<COLUMN NAME> [ASC / DESC])
-- PARTITION BY ------> OPTIONAL (ON GROUP OF ROWS).
-- ORDER BY -------> MANADATORY CLAUSE.

Similar codes

42 votes211 views6 answers
Install beautifulsoup
SQL
1 vote144 views1 answer
Ef core 5.0 usesqlserver not found
SQL
1 vote136 views1 answer
User privileges postgresql information_schema
SQL
0 vote93 views1 answer
Sql truncate table referencing itself
SQL
3 votes155 views1 answer
Oracle list invalid password logon denied
SQL
3 votes148 views2 answers
Host is not allowed to connect to this mysql server
SQL
12 votes145 views5 answers
Rename table in mysql
SQL
0 vote175 views2 answers
How to install psql in ubuntu
SQL
0 vote134 views1 answer
Authentication in sql server
SQL
4 votes146 views3 answers
Mysql modify foreign key
SQL