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 votes368 views1 answer
Q operator in oracle
SQL
0 vote326 views2 answers
Postgresql get last day of month
SQL
1 vote372 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote333 views1 answer
Power bi union columns
SQL
-1 vote348 views1 answer
Utf8_encode mysql
SQL
8 votes343 views5 answers
Grant permission in postgres
SQL
1 vote323 views1 answer
Mysql monthname
SQL
0 vote321 views1 answer
Original Query
SQL
0 vote307 views0 answer
SQL
0 vote348 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL