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 vote136 views1 answer
Oracle insert single quote in string
SQL
-1 vote75 views2 answers
Datetime sql server week
SQL
0 vote120 views1 answer
Change data type in mysql
SQL
1 vote151 views1 answer
Homebrew install mysql
SQL
0 vote158 views3 answers
Get count of null in column sql
SQL
2 votes111 views1 answer
Ifnull postgres
SQL
0 vote165 views1 answer
Grouping by email domain mysql
SQL
1 vote120 views1 answer
Base nosql
SQL
7 votes117 views3 answers
How ot change name of column mysql
SQL
0 vote125 views1 answer
Services.AddDbContext DataSource Sqlite
SQL