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 vote144 views1 answer
Mysql update privileges
SQL
-2 votes145 views2 answers
Add auto_increment column to existing table mysql
SQL
1 vote149 views1 answer
Show table status command in mysql
SQL
16 votes143 views1 answer
Mssql int max value
SQL
0 vote153 views1 answer
Sql server insert inner join
SQL
0 vote151 views1 answer
How to inner join 4 tables in sql
SQL
0 vote138 views1 answer
Match end of string regex sql
SQL
4 votes148 views3 answers
Check if two date ranges overlap sql server
SQL
6 votes139 views1 answer
Oracle desc table primary key
SQL
0 vote150 views2 answers
Unique key
SQL