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 vote119 views1 answer
Copy value from one column to another postgres
SQL
0 vote125 views1 answer
Sql select inside select sub query
SQL
0 vote139 views1 answer
Sql server remove primary key without dropping table
SQL
-1 vote124 views1 answer
Sql set max value in column
SQL
0 vote104 views1 answer
Database springboot
SQL
0 vote119 views1 answer
Mysql concatenate select results
SQL
1 vote115 views1 answer
Mysql select row max date
SQL
0 vote140 views1 answer
Mysql dump with table query
SQL
0 vote117 views1 answer
Pip install mysqlclient error
SQL
0 vote80 views1 answer
Update set with join pl sql
SQL