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 vote302 views2 answers
Homebrew nysql launch
SQL
0 vote571 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote307 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
3 votes307 views1 answer
Sql insert inserted id
SQL
0 vote375 views1 answer
Delet all record statment sql
SQL
2 votes303 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote296 views1 answer
Sql select random procentage from rows
SQL
0 vote299 views2 answers
How to get the date from datetime in mysql
SQL
0 vote341 views1 answer
Osm2pgsql mac
SQL
2 votes292 views1 answer
Oracle calculated column
SQL