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

0 vote127 views1 answer
Sql select where more than one record exists
SQL
0 vote118 views1 answer
Backup a table in sql
SQL
16 votes115 views6 answers
Mysql find and replace
SQL
12 votes116 views10 answers
Google
SQL
0 vote120 views1 answer
Postgresql alter column nullable
SQL
1 vote122 views2 answers
Extract weekday from date in sql
SQL
0 vote117 views1 answer
Connect by query in oracle
SQL
0 vote112 views1 answer
Generate sequence number in sql server
SQL
0 vote141 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
8 votes109 views3 answers
Oracle auto_increment
SQL