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 vote171 views1 answer
Mysql get only the field names in a table
SQL
0 vote159 views1 answer
Mariadb cast null to 0
SQL
2 votes144 views2 answers
Compare date mysql
SQL
0 vote154 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote163 views1 answer
MySql get primary keys of table
SQL
0 vote150 views1 answer
Pl sql constraint user function
SQL
0 vote159 views1 answer
Sql get guid
SQL
0 vote182 views1 answer
Postgresql conectar
SQL
0 vote171 views2 answers
Mysql dump structure only
SQL
0 vote158 views1 answer
Mysql query to add hours to column in table
SQL