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

1 vote279 views1 answer
Replace all numbers in mysql
SQL
1 vote289 views1 answer
Oracle get current schema
SQL
8 votes291 views6 answers
Sql insert
SQL
24 votes261 views5 answers
Sql server insert into select
SQL
0 vote257 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote275 views1 answer
Alter column to not null with default value sql server
SQL
0 vote269 views1 answer
Query string starts with vowels
SQL
0 vote258 views1 answer
C# select Mysql
SQL
1 vote276 views1 answer
Use of now() in mysql
SQL
0 vote284 views1 answer
Mssql unique key accept nulls
SQL