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 vote364 views2 answers
Regex starts with
SQL
1 vote350 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
2 votes381 views1 answer
Orcale index size
SQL
2 votes353 views2 answers
Mysql date range
SQL
1 vote344 views6 answers
In sql
SQL
0 vote372 views1 answer
Connect laravel to mysql on mac
SQL
19 votes361 views5 answers
Mysql between date range
SQL
0 vote363 views1 answer
Selecting all columns from table sql database
SQL
0 vote369 views1 answer
Sql convert datetime to year
SQL
2 votes377 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL