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 vote186 views1 answer
Postgresql check total storage
SQL
0 vote183 views1 answer
Can sqldatareader be null
SQL
0 vote180 views1 answer
MySQL FIND_IN_SET()
SQL
3 votes202 views5 answers
Foreign keys
SQL
0 vote168 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote181 views1 answer
Ms sql database data size
SQL
2 votes217 views1 answer
Python sql
SQL
4 votes180 views1 answer
Restart for pg_hba.conf file
SQL
0 vote238 views1 answer
Php insert null mysql
SQL
0 vote178 views1 answer
Mysql change timestamp on update
SQL