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 vote208 views1 answer
<sql:datasource var="Snapsho"
SQL
2 votes134 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
1 vote129 views1 answer
Mysql get domain from url
SQL
0 vote115 views1 answer
Dnsmasq.conf location macos
SQL
1 vote121 views1 answer
Postgres grant read only access to database
SQL
0 vote124 views1 answer
Change permission to database mysql
SQL
0 vote142 views1 answer
Sql waitfor
SQL
0 vote137 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote130 views1 answer
Sql delete from with relation
SQL
0 vote118 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL