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

1 vote221 views2 answers
Last working day in week date function in sql
SQL
0 vote271 views2 answers
Fanyi
SQL
0 vote213 views1 answer
How to create a new db from dumb file mysql
SQL
1 vote227 views1 answer
Cross schema query oracle 2 users
SQL
1 vote217 views2 answers
Mysql remove first and last character from string
SQL
0 vote219 views1 answer
How to export only procedures mysql
SQL
1 vote216 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote237 views1 answer
Postgresql create table many-to-many
SQL
2 votes261 views1 answer
Mysql select true or false
SQL
0 vote227 views1 answer
Sql tablo sp
SQL