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;

Similar codes

0 vote151 views1 answer
Alter table add check constraint oracle
SQL
8 votes146 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote165 views1 answer
How to fetch data from database in sql
SQL
0 vote135 views1 answer
Stuff in sql server
SQL
2 votes157 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
7 votes125 views1 answer
Safe mode mysql
SQL
3 votes160 views1 answer
Convert sqlite table to pandas dataframe
SQL
1 vote137 views1 answer
Check constraint to check if date greater than todays date
SQL
16 votes167 views3 answers
Get count of duplicate records
SQL
1 vote146 views1 answer
Set autoincrement to 0
SQL