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 vote108 views1 answer
Google cloud sql postgres url example
SQL
0 vote112 views1 answer
Using distinct and count together in sql
SQL
0 vote197 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote96 views2 answers
SQL Server Standard
SQL
3 votes120 views2 answers
Mysql import gz
SQL
0 vote113 views1 answer
To_date sql
SQL
2 votes144 views1 answer
Orcale index size
SQL
5 votes112 views1 answer
Oracle asynchronous update
SQL
0 vote108 views1 answer
Normalization in database 2nd normal form
SQL
18 votes112 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL