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

4 votes337 views1 answer
To date oracle with time
SQL
1 vote538 views3 answers
Create table from existing table in sql
SQL
0 vote364 views5 answers
How to make trigger in phpmyadmin
SQL
17 votes329 views5 answers
Order by sql
SQL
0 vote382 views1 answer
Python sql last insertend
SQL
1 vote370 views1 answer
Mysql select and count left join
SQL
65 votes581 views6 answers
Sql add column to table
SQL
31 votes350 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote345 views1 answer
Oracle character index
SQL
8 votes370 views1 answer
Oracle add auto_increment column to existing table
SQL