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

5 votes317 views1 answer
Alter table default value mysql
SQL
0 vote364 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote362 views1 answer
Sql create text column limited values
SQL
0 vote345 views1 answer
Sql server remove 0 from left
SQL
0 vote360 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote353 views1 answer
Mysql pad zeros
SQL
0 vote419 views1 answer
Sql decimal to 2 places
SQL
1 vote377 views2 answers
Mysql show views
SQL
0 vote342 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote365 views1 answer
How to create a new db from dumb file mysql
SQL