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

10 votes123 views1 answer
Oracle view dependencies
SQL
0 vote173 views1 answer
Python list from sql
SQL
0 vote190 views1 answer
How to get nth number in sql
SQL
1 vote171 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
13 votes127 views2 answers
Oracle all source
SQL
3 votes191 views2 answers
Sqlite show table structure
SQL
7 votes164 views3 answers
How ot change name of column mysql
SQL
0 vote134 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote169 views1 answer
Postgres enumerated type
SQL
0 vote176 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL