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 vote167 views1 answer
Sql cursor example multiple columns
SQL
1 vote171 views1 answer
Load sql into mamp
SQL
0 vote174 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
6 votes178 views2 answers
Drop foreign key
SQL
1 vote165 views1 answer
Sql not equal multiple columns
SQL
2 votes171 views1 answer
Sqlite show table indexes
SQL
31 votes173 views3 answers
Sql count(*)
SQL
-1 vote187 views3 answers
Compute age mysql
SQL
0 vote184 views1 answer
Alter rename command in mysql
SQL
7 votes175 views2 answers
MySQL IF without else
SQL