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 vote222 views4 answers
Postgres between dates
SQL
0 vote218 views1 answer
Sql select rows with different values in one column
SQL
0 vote184 views1 answer
Mysql DDL
SQL
8 votes188 views3 answers
SQL column name
SQL
1 vote170 views1 answer
Substr sql last character
SQL
0 vote183 views1 answer
Generate sequence number in sql server
SQL
1 vote243 views2 answers
Mysql SELECT
SQL
13 votes169 views2 answers
Sql count distinct group by
SQL
14 votes182 views2 answers
Oracle limit rows
SQL
0 vote187 views1 answer
Every Derived yable must have its own alias
SQL