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 vote163 views2 answers
Logical operators in sql
SQL
0 vote141 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
1 vote139 views1 answer
How to get mysql db size
SQL
-1 vote137 views1 answer
Plsql while
SQL
21 votes146 views1 answer
Cheatsheet for sql
SQL
0 vote171 views1 answer
Postgressql uuid
SQL
1 vote151 views1 answer
Altering the column name in MySQL to have a default value
SQL
22 votes201 views4 answers
Mysql format date
SQL
0 vote145 views1 answer
Top frequency in sql server
SQL
0 vote148 views1 answer
Mysql date format unix timestamp
SQL