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 vote340 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote333 views1 answer
Oracle step procedure
SQL
3 votes338 views2 answers
Sql server current date without time
SQL
11 votes355 views2 answers
How to import mysql database command line
SQL
0 vote330 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
7 votes337 views4 answers
Mysql delete older duplicates
SQL
-1 vote367 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote304 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote310 views2 answers
Sql regex vowel
SQL
0 vote317 views1 answer
Update set with inner join oracle
SQL