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

50 votes195 views6 answers
Install mysql on ubuntu
SQL
0 vote198 views1 answer
SQL check if record exist
SQL
2 votes183 views1 answer
Postgresql create table as select
SQL
0 vote176 views1 answer
How to find all children of a record with only parent ID in sql
SQL
1 vote270 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
1 vote193 views2 answers
Mysql switch case
SQL
0 vote167 views1 answer
Sql insert query list of dictionaries
SQL
1 vote171 views2 answers
Sql select only first occurrence
SQL
0 vote175 views1 answer
Copy data from one postgres container to another
SQL
0 vote165 views2 answers
Select limit ms sql
SQL