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

14 votes121 views2 answers
Oracle limit rows
SQL
12 votes123 views1 answer
Script to add new column in table sql
SQL
0 vote110 views1 answer
Sqlite explain plan
SQL
9 votes139 views1 answer
Alter table column change data type to text mysql
SQL
0 vote115 views1 answer
Set default value now() date
SQL
0 vote130 views1 answer
Mysql min value row
SQL
0 vote124 views1 answer
Oracle cpu metric
SQL
1 vote104 views1 answer
Using SQL in rails migration
SQL
0 vote134 views2 answers
Install phoenix
SQL
3 votes112 views1 answer
How to remove characters from string in mysql
SQL