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

2 votes142 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote118 views1 answer
10000000000000000000 am to meters
SQL
0 vote107 views1 answer
SQL division of an integer by another integer get float CAST
SQL
1 vote134 views1 answer
Sql server update column based on another table
SQL
0 vote139 views2 answers
What is rownum in oracle
SQL
11 votes126 views2 answers
Having in sql
SQL
0 vote124 views1 answer
Procedure excute monthly oracle
SQL
0 vote160 views1 answer
Sparql if bound query
SQL
0 vote119 views1 answer
T-SQL Never ending DELETE
SQL
0 vote137 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL