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 vote329 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote316 views1 answer
How to select a row in sql
SQL
1 vote284 views1 answer
Minus vs intersect in sql
SQL
6 votes294 views1 answer
Postgresql get year
SQL
1 vote305 views1 answer
Show per page table in xampp
SQL
12 votes337 views5 answers
Rename table in mysql
SQL
3 votes293 views3 answers
Mysqldump: couldn
SQL
0 vote317 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote315 views1 answer
Sintaxis SELECT sql
SQL
6 votes305 views5 answers
Mysql get last insert id
SQL