Sql rank

-- Employees per department, ranked in salary order
SELECT EMPNO,
       DEPTNO,
       SAL,
       rank() OVER (PARTITION BY DEPTNO ORDER BY SAL) AS MYRANK
FROM EMP;

Source: oracle-base.com

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 vote122 views1 answer
QCompleter con sql
SQL
0 vote137 views1 answer
How to set sql_mode for a query in CI model
SQL
9 votes131 views4 answers
Add primary key to existing table sql
SQL
0 vote147 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote103 views2 answers
Sql update from two different database
SQL
0 vote224 views1 answer
Database timezone
SQL
0 vote139 views1 answer
Create table database in psql
SQL
-1 vote185 views4 answers
Full outer join in sql
SQL
2 votes208 views1 answer
Mysql create user with remote access
SQL
0 vote170 views1 answer
Alter database name script
SQL