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

2 votes100 views1 answer
Latest record in sql
SQL
1 vote125 views1 answer
How to between in sql
SQL
0 vote132 views3 answers
Java hide mysql login credentials
SQL
1 vote129 views1 answer
Postgres set column equal to another
SQL
0 vote167 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
1 vote126 views1 answer
Media sql
SQL
4 votes130 views1 answer
Restart for pg_hba.conf file
SQL
0 vote128 views1 answer
Parsing float to int in mysql
SQL
3 votes145 views1 answer
Oracle undo tablespace schema
SQL
0 vote120 views1 answer
Kotlin sqlite delete row
SQL