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

32 votes153 views6 answers
Insert select
SQL
0 vote156 views1 answer
How to import sqlite driver class in java using maven
SQL
2 votes171 views1 answer
Sql count having
SQL
-1 vote165 views4 answers
Restart mysql server ubuntu
SQL
15 votes139 views4 answers
T-sql drop function if exists
SQL
0 vote156 views1 answer
How to install mysql without admin rights
SQL
0 vote145 views1 answer
Postrgres trunc
SQL
1 vote186 views1 answer
Opensuse restart MySQL
SQL
0 vote163 views1 answer
Get null value in sql
SQL
1 vote142 views1 answer
Nested if in mysql
SQL