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 vote193 views1 answer
Mysql create pool
SQL
8 votes188 views1 answer
Today minus 15 days postgresql
SQL
5 votes200 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
1 vote229 views2 answers
Sql now - 1 day
SQL
2 votes180 views2 answers
Join update query in sql
SQL
-1 vote142 views3 answers
Ubuntu install mssql
SQL
7 votes237 views1 answer
Sql disable safe mode
SQL
0 vote190 views1 answer
Mysql drop multiple tables at once
SQL
2 votes183 views1 answer
Sql to char function with date
SQL
0 vote191 views1 answer
Postgresql comandos basicos
SQL