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 vote196 views1 answer
Oracle procedure chain step
SQL
6 votes190 views1 answer
Rank function in oracle with example
SQL
0 vote203 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote211 views1 answer
Sqlserver create table from select
SQL
1 vote200 views1 answer
T-SQL Alter the column data type
SQL
9 votes195 views4 answers
Mysql show table fields
SQL
1 vote190 views2 answers
Limit sqlserver
SQL
21 votes225 views1 answer
SQL cheat sheet pdf
SQL
1 vote196 views1 answer
Select 2 rows in sql
SQL
0 vote209 views1 answer
Mysql set column equal to another automatic
SQL