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 vote168 views2 answers
Mysql show foreign keys
SQL
0 vote141 views1 answer
Postgres statistics
SQL
1 vote205 views1 answer
Oracle datafile max size 32gb
SQL
1 vote169 views1 answer
Drop colum oracle 18c
SQL
0 vote130 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote134 views4 answers
Mysql desactivar trigger
SQL
0 vote154 views1 answer
Postgresql list extensions
SQL
0 vote167 views1 answer
Add new column in sql with foreign key
SQL
0 vote142 views1 answer
Comparing with today and yesterday record in sql query
SQL
7 votes193 views2 answers
Oracle foreign key reference table
SQL