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 vote330 views1 answer
Move table to a different schema
SQL
0 vote315 views1 answer
Mysql aspas simples
SQL
10 votes299 views1 answer
Oracle all_dependencies
SQL
1 vote320 views1 answer
How to use db.execute
SQL
1 vote305 views2 answers
How to enable error squiggles in vs code
SQL
9 votes283 views2 answers
Default number in sql
SQL
0 vote302 views1 answer
Show create table in postgresql
SQL
11 votes318 views1 answer
Oracle view source
SQL
0 vote321 views1 answer
Watch mysql command line
SQL
0 vote296 views1 answer
Set column width in sqlplus
SQL