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

1 vote210 views1 answer
Show structure of table in sql
SQL
0 vote209 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote199 views1 answer
Including parameters in OPENQUERY
SQL
0 vote222 views1 answer
How to generate ids in sql
SQL
0 vote207 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
-1 vote204 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote219 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
9 votes232 views3 answers
Date format in sql
SQL
3 votes157 views1 answer
How to get list of synonyms in oracle
SQL
0 vote164 views1 answer
Print sum of values sql
SQL