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 votes144 views2 answers
Postgres add column integer
SQL
0 vote155 views1 answer
Sql delete caracter list
SQL
0 vote94 views1 answer
Finish transaction sql
SQL
0 vote149 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
12 votes139 views4 answers
Mysql version
SQL
8 votes131 views1 answer
Sql limit results returned
SQL
0 vote133 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
4 votes134 views4 answers
Sqlite describe table
SQL
0 vote128 views1 answer
If null don't update
SQL
7 votes128 views2 answers
Show size database mysql
SQL