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 vote322 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote280 views1 answer
Find most frequent value in SQL column
SQL
0 vote289 views1 answer
Which lock mode is not available in sql
SQL
0 vote306 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote243 views1 answer
Mysql find foreign key references
SQL
0 vote287 views1 answer
Hex string sql becomes int64
SQL
0 vote282 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote307 views1 answer
C# execute transact sql
SQL
31 votes286 views4 answers
How to get duplicate records with multiple field in sql
SQL
-1 vote274 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL