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 vote335 views1 answer
Cast float mysql
SQL
0 vote323 views1 answer
Check if database exists sql
SQL
4 votes294 views1 answer
Mac install mysql
SQL
33 votes326 views2 answers
Postgres how to add field created at
SQL
0 vote319 views1 answer
Mysql concat and use as where column
SQL
0 vote326 views2 answers
PostgreSQL having
SQL
0 vote331 views1 answer
Sql date d'aujourd'hui
SQL
2 votes304 views1 answer
Oracle sql query to make column data uppercase
SQL
2 votes346 views1 answer
Oracle to_char number format percentage
SQL
2 votes339 views1 answer
Datetrunc
SQL