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 vote276 views1 answer
Create table with float datatype in sql server
SQL
1 vote239 views2 answers
Delete auto increment mysql
SQL
2 votes307 views1 answer
Oracle Column Names of a table
SQL
1 vote263 views1 answer
Truncate left characters mysql
SQL
0 vote287 views1 answer
Insert ip address in mysql
SQL
0 vote274 views3 answers
Osx stop mysql service
SQL
0 vote285 views1 answer
Mysql last 6 months
SQL
0 vote265 views1 answer
Where in clause tsql
SQL
4 votes269 views1 answer
Select first and last row sql
SQL
4 votes252 views2 answers
How to count items with same name in sql
SQL