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

1 vote225 views1 answer
Set id count mysql
SQL
0 vote215 views1 answer
Sql show table name in result
SQL
-1 vote199 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote214 views1 answer
Psql generate id in existing database
SQL
0 vote224 views1 answer
C# get sql min date
SQL
0 vote203 views1 answer
Extract sql from query object sqlalchemy
SQL
-2 votes196 views1 answer
Modify column name in tsql
SQL
0 vote200 views1 answer
Sql select column names starting with
SQL
3 votes211 views2 answers
Sql select data from last week
SQL
0 vote218 views4 answers
Mysql desactivar trigger
SQL