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 vote289 views1 answer
Deleted table in sql trigger
SQL
0 vote311 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote295 views1 answer
How to check replication lag in mySQL
SQL
10 votes360 views2 answers
Mysql remove only_full_group_by permanently
SQL
18 votes321 views3 answers
Mysql current date
SQL
1 vote321 views1 answer
How to make a select in sql
SQL
0 vote324 views1 answer
Oracle sql date winter time
SQL
15 votes317 views2 answers
Sql order by multiple columns
SQL
0 vote334 views1 answer
Compare two tables to find unmatched records
SQL
11 votes353 views1 answer
Ddl view
SQL