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 vote207 views1 answer
Hallo
SQL
0 vote233 views2 answers
Postgres show current role
SQL
0 vote222 views1 answer
Incorrect string value: mysql
SQL
5 votes239 views1 answer
Invalid column name sql
SQL
2 votes223 views1 answer
Alter table add multiple columns postgresql
SQL
0 vote231 views2 answers
Identity column in sql server
SQL
-1 vote220 views1 answer
MYSQL stored procedure select from
SQL
0 vote228 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
36 votes236 views6 answers
Rename table sql
SQL
1 vote209 views2 answers
Difference between in and between in sql
SQL