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 vote272 views1 answer
Postgresql heritage
SQL
0 vote241 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote259 views1 answer
Mysql export data with a where clause
SQL
0 vote337 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote260 views1 answer
How to remove default in mysql
SQL
0 vote257 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote264 views1 answer
Postgres call view
SQL
0 vote270 views1 answer
Sqlite commands
SQL
0 vote283 views1 answer
Drop-toys-table
SQL
0 vote263 views1 answer
Date diff sql
SQL