Query for maximum salary

Sql highest salary by location

/*  Highest salary by Department/Location   */
SELECT e.ename, e.sal, e.deptno, d.loc
FROM emp e
JOIN dept d
ON e.deptno = d.deptno
WHERE e.sal in
( 	
  	select max(sal) 
  	from emp 
  	group by deptno
)

Source: grepper.com

Similar codes

0 vote172 views1 answer
Oracle date summer time
SQL
0 vote163 views1 answer
Grant privileges mysql to database 1064
SQL
13 votes154 views2 answers
Sql online compiler
SQL
1 vote139 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote142 views1 answer
Find number of entries sql
SQL
5 votes142 views5 answers
Sqlite install python
SQL
0 vote134 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
4 votes155 views4 answers
Pl sql output
SQL
0 vote162 views1 answer
Mysql get only the field names in a table
SQL
0 vote143 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL