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 vote126 views1 answer
Sql server list user permissions
SQL
3 votes137 views1 answer
Sql multi column index performance
SQL
1 vote144 views1 answer
Postgres format date in select
SQL
1 vote146 views1 answer
Psql connect to another database
SQL
0 vote138 views1 answer
Sp in sql server
SQL
0 vote119 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote126 views1 answer
Postgres week number
SQL
0 vote136 views1 answer
TSQL function split string
SQL
0 vote120 views1 answer
Mysql sql select one day before
SQL
0 vote139 views1 answer
Hex string sql becomes int64
SQL