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

2 votes125 views1 answer
Scaffold npgsql net core
SQL
0 vote159 views1 answer
Sql developer format sql
SQL
0 vote131 views1 answer
Oracle list dblink
SQL
0 vote147 views1 answer
Redshift running queries
SQL
3 votes137 views2 answers
Truncate all tables
SQL
0 vote127 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote110 views1 answer
Jooq finding lastest value in table
SQL
3 votes128 views2 answers
Find the median in sql
SQL
3 votes136 views1 answer
Postgresql db owner change
SQL
16 votes138 views2 answers
Oracle ddl
SQL