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 votes295 views4 answers
Rollback in sql
SQL
1 vote312 views1 answer
Sql view where tables have same column name combine results
SQL
1 vote271 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote296 views1 answer
Ver usuarios mysql
SQL
0 vote277 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote231 views1 answer
Mysql collation for all languages
SQL
1 vote273 views1 answer
Delete mysql from mac
SQL
0 vote286 views1 answer
Oracle exchange partition
SQL
0 vote267 views1 answer
MySQL FIND_IN_SET()
SQL
15 votes284 views2 answers
Select Options
SQL