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 vote146 views1 answer
Oracle list datafiles
SQL
1 vote150 views1 answer
Mysql select if empty result
SQL
7 votes147 views1 answer
Connect mysql docker
SQL
0 vote144 views1 answer
Add column in sql server ubuntu
SQL
6 votes155 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote155 views1 answer
Psql check if sql script is valid
SQL
0 vote149 views1 answer
Update view sql
SQL
3 votes140 views2 answers
Postgresql remove not null constraint
SQL
1 vote141 views3 answers
Execute sp in sql server
SQL
0 vote162 views1 answer
Codigo crear tablas sql server
SQL