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 vote239 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
2 votes223 views2 answers
Mysql date range
SQL
0 vote208 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote234 views2 answers
Sql query inner join 3 tables
SQL
0 vote202 views1 answer
Opensuse status MySQL
SQL
1 vote219 views1 answer
Not exists mysql
SQL
1 vote211 views1 answer
Update from select join
SQL
0 vote232 views1 answer
Datetime postgres typeorm
SQL
0 vote227 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote240 views1 answer
Sql decimal to 2 places
SQL