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

13 votes298 views6 answers
Mysql update from select
SQL
0 vote322 views4 answers
Sql rownum
SQL
2 votes299 views1 answer
Postgresql left join distinct on
SQL
0 vote337 views1 answer
For row in sql database python loop
SQL
0 vote291 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote338 views1 answer
Mysql, how to query the table comments?
SQL
0 vote307 views1 answer
Postgres sequence name
SQL
10 votes282 views3 answers
Insert into auto increment mysql
SQL
2 votes324 views1 answer
Show max_allowed_packet mysql
SQL
2 votes300 views1 answer
Postgresql create schema in specific database
SQL