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 vote189 views1 answer
Mysql zerofill
SQL
0 vote235 views1 answer
Authentication modes in sql server
SQL
0 vote176 views1 answer
Run mssql server terminal
SQL
1 vote179 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote146 views1 answer
Mysql insert with foreign key
SQL
23 votes149 views3 answers
Mysqldump
SQL
1 vote205 views1 answer
Drop colum oracle 18c
SQL
0 vote197 views2 answers
Get item by composite primary key mysql
SQL
19 votes291 views5 answers
Mysql between date range
SQL
3 votes193 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL