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

1 vote366 views2 answers
Test sqlsrv connection
SQL
0 vote374 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote376 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote382 views1 answer
Postgresql create table many-to-many
SQL
1 vote390 views1 answer
Sql how to replace full stop
SQL
0 vote346 views1 answer
How to check if there is no database schema
SQL
2 votes384 views2 answers
Mysql count rows returned
SQL
0 vote372 views1 answer
Database traccar
SQL
0 vote700 views1 answer
Create pl/sql stored procedure
SQL
2 votes422 views1 answer
Cannot return non-composite value from function that returns composite type
SQL