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

1 vote358 views2 answers
Sql insert timestamp
SQL
0 vote338 views1 answer
Sql contains numeric characters
SQL
0 vote324 views1 answer
How to open mysql in docker
SQL
1 vote350 views1 answer
Mysql breakline on string
SQL
0 vote272 views1 answer
Update sql join multiple tables
SQL
0 vote334 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote333 views1 answer
Cannot start database server xampp mac os
SQL
0 vote335 views1 answer
Postgres populate table from another table
SQL
2 votes333 views1 answer
Drop all database tables oracle sql developer
SQL
1 vote310 views1 answer
Column with prefix in sql
SQL