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

24 votes207 views6 answers
Alter table name sql
SQL
3 votes183 views2 answers
Mysql update row
SQL
0 vote174 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote249 views1 answer
Fetching data from mysqldb
SQL
0 vote186 views1 answer
Sql if else in select
SQL
2 votes171 views1 answer
Oracle sql drop column if exists
SQL
-1 vote181 views1 answer
How to switch user in mysql
SQL
1 vote219 views1 answer
Sql string function update replace
SQL
0 vote183 views1 answer
Mysql match in serialized data
SQL
0 vote190 views1 answer
Google sheets filter rows above current cell
SQL