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 votes122 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote95 views1 answer
Select other columns with distinct
SQL
1 vote94 views1 answer
How refresh navicat tables to see new tables
SQL
2 votes104 views2 answers
Laravel query builder toSql
SQL
0 vote96 views1 answer
Raiserror nowait sql server
SQL
2 votes88 views1 answer
Mysql auto increment jumping
SQL
0 vote118 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote131 views1 answer
Hour differeence in mysql
SQL
0 vote112 views4 answers
How to drop all tables in sql
SQL
0 vote103 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL