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

4 votes302 views1 answer
Mysql copy table with new name
SQL
1 vote307 views1 answer
Mysql datetime with timezone offset
SQL
2 votes306 views2 answers
Postgres change owner of schema
SQL
0 vote294 views1 answer
Sqlalchemy query join many to many
SQL
3 votes303 views2 answers
Mysql import gz
SQL
0 vote281 views1 answer
Flask sqlalchemy update row
SQL
2 votes319 views5 answers
Install postgresql 10 centos 7
SQL
0 vote278 views1 answer
Sql query with date
SQL
0 vote281 views2 answers
Show slave status mysql
SQL
-1 vote299 views2 answers
Sql convert date to string yyyy-mm-dd
SQL