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 vote228 views1 answer
Select top 3 sql
SQL
0 vote199 views1 answer
Flask_sqlalchemy install
SQL
0 vote245 views1 answer
Sql on-premises
SQL
-1 vote243 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote236 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
1 vote232 views1 answer
Oracle rolling back
SQL
1 vote255 views1 answer
Window function mysql
SQL
0 vote233 views1 answer
Set mysql socket file docker windows
SQL
3 votes239 views1 answer
Oracle apex warn on unsaved changes
SQL
6 votes223 views1 answer
Postgresql get year
SQL