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 vote123 views1 answer
Stored function in sql
SQL
0 vote101 views1 answer
Sqlite3 not commit
SQL
51 votes179 views6 answers
Change column name sql
SQL
0 vote118 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote114 views1 answer
Find number of entries sql
SQL
-1 vote120 views1 answer
Sql add column bit
SQL
0 vote121 views1 answer
Max length found in mysql
SQL
1 vote119 views1 answer
Postgresql reset serial counter after deleting content
SQL
6 votes118 views2 answers
Mysql execute file
SQL
16 votes141 views3 answers
T-SQL Add Column
SQL