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 vote194 views1 answer
Pl sql join 3 tables
SQL
2 votes147 views1 answer
Foreign key example in dbms
SQL
0 vote198 views1 answer
Get current date data in mysql
SQL
0 vote227 views1 answer
Sqlcl format
SQL
0 vote194 views1 answer
Psql list view rules
SQL
0 vote193 views1 answer
Select last 2 characters sql
SQL
0 vote203 views1 answer
How to delete python anywhere mysql database
SQL
1 vote203 views1 answer
Oracle avg
SQL
0 vote198 views1 answer
Primary key multiple colums
SQL
0 vote219 views1 answer
Insufficient privileges while creating view in sql oracle
SQL