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

5 votes263 views1 answer
Oracle columns in all_tables
SQL
0 vote208 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
6 votes196 views1 answer
Postgresql add enum value
SQL
5 votes280 views1 answer
Mysql last day of next month
SQL
4 votes192 views1 answer
SQL order random
SQL
4 votes198 views1 answer
Phone number sql
SQL
12 votes204 views6 answers
Between in sql
SQL
3 votes186 views2 answers
Mysql add 2 hours
SQL
0 vote197 views2 answers
Update all linkedserver tables with openquery on db
SQL
1 vote217 views1 answer
How to delay stored procedure execution in sql server
SQL