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 vote358 views1 answer
Last 24 HOUR data in mysql
SQL
1 vote460 views3 answers
Uninstall postgresql mac
SQL
2 votes327 views2 answers
Mysql find max value row
SQL
5 votes341 views1 answer
Sql integer to serial
SQL
0 vote264 views1 answer
Update sql join multiple tables
SQL
2 votes346 views2 answers
Sqlalchemy return id after insert
SQL
0 vote299 views1 answer
Mysql database is not starting in xampp
SQL
0 vote314 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote337 views1 answer
Oracle table privileges
SQL
1 vote314 views1 answer
Sql find column name like
SQL