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

2 votes181 views1 answer
Sql server find table name
SQL
0 vote187 views1 answer
Get all employee of salary if more than in sql
SQL
1 vote206 views1 answer
Add current timestamp in mysql
SQL
3 votes243 views1 answer
Oracle detect invalid password
SQL
1 vote196 views2 answers
Pl sql case
SQL
1 vote207 views1 answer
Isnull sql server
SQL
0 vote188 views1 answer
How to export table data from mysql table in sql format
SQL
5 votes268 views2 answers
Add days in oracle sql
SQL
12 votes188 views3 answers
Install sqlite driver ubuntu
SQL
1 vote199 views1 answer
Oracle stop job
SQL