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 vote160 views1 answer
Mysql isshow
SQL
0 vote174 views1 answer
Connect by query in oracle
SQL
0 vote186 views2 answers
How to see table associated with a schema in sql
SQL
0 vote170 views1 answer
Primary key multiple colums
SQL
6 votes158 views5 answers
Alter table oracle
SQL
1 vote273 views1 answer
Alter constraint postgres
SQL
0 vote197 views1 answer
Sqlcl format
SQL
0 vote161 views1 answer
Cross apply top for each row t1
SQL
8 votes182 views1 answer
Declare table variable sql server
SQL
1 vote178 views2 answers
Sql drop multiple columns if exists
SQL