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 vote257 views2 answers
Plan d'exécution requete oracle autotracer
SQL
2 votes274 views1 answer
Guid to string sql
SQL
22 votes282 views3 answers
Remove all records from table mysql
SQL
2 votes284 views2 answers
Postgres add column integer
SQL
3 votes299 views1 answer
Sql double index
SQL
0 vote270 views1 answer
Postgres execute multiple sql file from command line
SQL
1 vote280 views3 answers
How to filter repeated same result using sql query
SQL
2 votes259 views1 answer
Apex date today add days
SQL
1 vote279 views1 answer
Sqlite update from another table
SQL
0 vote257 views1 answer
Show table structure mysql console
SQL