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 vote167 views1 answer
Reutrn string after character sql
SQL
0 vote198 views1 answer
Sql: extract day text from datetime value
SQL
0 vote220 views1 answer
Creating sqeuence in oracle database
SQL
0 vote179 views1 answer
Pl sql constraint user function
SQL
6 votes187 views1 answer
Oracle trigger after logon on database
SQL
2 votes178 views1 answer
How to create sql database
SQL
0 vote168 views1 answer
Full syntax inner join
SQL
1 vote153 views1 answer
Foreign key in oracle sql developer
SQL
0 vote169 views1 answer
Mysql connection with sqlalchecmy
SQL
-1 vote189 views1 answer
Search all database tables for a value sqlserver
SQL