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

16 votes264 views3 answers
Order by sql query
SQL
1 vote292 views1 answer
Psql connect
SQL
0 vote300 views1 answer
Order child below the parent in mysqli
SQL
20 votes271 views5 answers
Reset auto increment mysql
SQL
0 vote271 views1 answer
Sql server select top 2 of each group
SQL
0 vote296 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote277 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote270 views1 answer
View acl table oracle
SQL
3 votes331 views2 answers
Oracle drop sequence
SQL
11 votes286 views1 answer
Get ddl materialized view oracle
SQL