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

3 votes223 views2 answers
Sqlite show table structure
SQL
7 votes253 views1 answer
Sql disable safe mode
SQL
0 vote209 views1 answer
Get role postgres
SQL
1 vote215 views2 answers
Mysql error 1215
SQL
2 votes225 views1 answer
Mysql cannot delete or update a parent row
SQL
1 vote230 views1 answer
Events mysql
SQL
0 vote193 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote248 views1 answer
Oracle sql date winter time
SQL
1 vote205 views2 answers
Mysql extract month
SQL
2 votes249 views2 answers
How to add not null constraint in sql
SQL