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 vote354 views1 answer
Duplicate value unique constraint mysql error
SQL
29 votes354 views6 answers
Delete all rows from table mysql
SQL
1 vote358 views1 answer
How to check the mysql version mac
SQL
0 vote345 views1 answer
How to check if there is no database schema
SQL
4 votes308 views1 answer
Oracle sleep
SQL
20 votes356 views3 answers
SQL query rename table
SQL
0 vote355 views1 answer
Alter table myisam to innodb
SQL
0 vote341 views1 answer
Sqlite select split string
SQL
0 vote344 views1 answer
Remove default constraint sql server
SQL
1 vote358 views1 answer
Spring postgresql reset auto increment to 0
SQL