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

1 vote249 views2 answers
List tables sqlalchemy
SQL
10 votes247 views4 answers
Else if mysql
SQL
1 vote312 views1 answer
Adding a check statement in sql
SQL
1 vote184 views1 answer
Set all the vluses in calumn in sql to false
SQL
2 votes190 views1 answer
Sql ignore accents
SQL
6 votes286 views2 answers
Non relational database
SQL
8 votes180 views1 answer
How to remove tables from postgresql
SQL
2 votes180 views3 answers
Mysql unix timestamp to date
SQL
0 vote212 views1 answer
Pgadmin check database
SQL
2 votes203 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL