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 vote192 views1 answer
Grant privileges of databse to user
SQL
0 vote194 views1 answer
Psql list view rules
SQL
1 vote209 views1 answer
Create table variable in sql stored procedure
SQL
0 vote201 views1 answer
Generate sequence number in sql server
SQL
1 vote192 views1 answer
Last 6 months postgresql
SQL
10 votes167 views2 answers
Sql where clause multiple values
SQL
0 vote275 views1 answer
Postgressql uuid
SQL
1 vote211 views2 answers
Procedure syntax
SQL
10 votes198 views1 answer
Query to find object dependencies in oracle
SQL
0 vote255 views1 answer
Isnull in sqlite
SQL