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

0 vote197 views3 answers
Joins and views sql
SQL
0 vote276 views1 answer
Replace null value within column mysql
SQL
0 vote210 views1 answer
Utiliser sql ligne de commande
SQL
5 votes306 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote155 views1 answer
FindAllBy
SQL
1 vote263 views1 answer
Opensuse restart MySQL
SQL
3 votes231 views1 answer
Laravel paginate raw sql
SQL
7 votes211 views1 answer
Buy forge mods server hosting
SQL
9 votes219 views2 answers
Convert data type in sql
SQL
-1 vote211 views5 answers
Online sql to linq generator
SQL