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

16 votes326 views2 answers
Sql vs nosql
SQL
0 vote261 views1 answer
Remove binlog mysql
SQL
0 vote246 views1 answer
How to change the field size of an existing column
SQL
0 vote262 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote253 views1 answer
How to create a new shema using query languaage
SQL
0 vote270 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote282 views1 answer
Delete a temporary table mysql
SQL
0 vote291 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote258 views1 answer
Get the Db column names from a SqlDataReader
SQL
1 vote261 views1 answer
Get last week data in mysql
SQL