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 vote364 views1 answer
TSQL Find csv file in folder
SQL
1 vote326 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote309 views3 answers
Postgres date difference seconds
SQL
0 vote321 views1 answer
Add new column in sql with foreign key
SQL
9 votes282 views3 answers
Oracle undo usage by session
SQL
0 vote341 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
3 votes306 views1 answer
Only join in sql
SQL
0 vote273 views1 answer
Get created time of database psql 8
SQL
0 vote326 views1 answer
How to check rollback status in oracle
SQL
0 vote287 views1 answer
Vbscript clean up ADODB.Recordset
SQL