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 vote271 views1 answer
Mysql grant grant option
SQL
0 vote295 views1 answer
Modifier une valeur sql
SQL
0 vote299 views1 answer
Joomla execute raw sql
SQL
0 vote263 views1 answer
Cast as decimal postgresql
SQL
3 votes278 views1 answer
Null sql
SQL
0 vote271 views1 answer
Sql menampilkan data tabel
SQL
0 vote251 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote284 views1 answer
Mysql disable triggers
SQL
1 vote282 views1 answer
Quit mysql
SQL
2 votes264 views3 answers
Current month mysql query
SQL