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 vote345 views1 answer
Get who is hired in month in sql
SQL
3 votes365 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
2 votes323 views5 answers
Alter table primary key postgresql
SQL
0 vote400 views1 answer
Remove mysql from centos 7
SQL
0 vote325 views1 answer
Mysql workbench primary key
SQL
0 vote329 views1 answer
Sql query to check if column contains alphabets
SQL
1 vote334 views1 answer
Oracle apex run 404
SQL
3 votes355 views1 answer
Mysql insert on dupèlicate
SQL
0 vote387 views1 answer
Sql trim whitespace
SQL
0 vote345 views1 answer
Create new schema mysql
SQL