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 vote185 views1 answer
Deny select insert update delete sql
SQL
2 votes217 views3 answers
Sql truncate table
SQL
5 votes205 views2 answers
Create function postgresql
SQL
0 vote189 views2 answers
Sql regex vowel
SQL
0 vote207 views1 answer
Select 1 from orders
SQL
1 vote200 views2 answers
T sql get foreign key
SQL
0 vote187 views1 answer
Download mysql database to excel in android studio
SQL
1 vote145 views1 answer
Oracle compile schema
SQL
1 vote181 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote185 views1 answer
SQL get max per id
SQL