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 votes283 views1 answer
Mysql select greater than yesterday
SQL
0 vote292 views1 answer
Can we rollback deleted data in sql
SQL
1 vote323 views1 answer
Psql connect
SQL
4 votes297 views1 answer
Adding data to table in sql python
SQL
0 vote295 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote309 views1 answer
Merge clause with inner join
SQL
1 vote319 views1 answer
Name of today sql
SQL
2 votes251 views1 answer
Sql float to int
SQL
0 vote273 views1 answer
Sql truncate table referencing itself
SQL
0 vote329 views1 answer
Find the names of sailors who have reserved at least one boat
SQL