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 vote158 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote123 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote151 views1 answer
How to insert same table data using mysql query
SQL
0 vote126 views1 answer
Case when with count and combining similar values in sql
SQL
2 votes144 views1 answer
How to get non distinct values in sql
SQL
1 vote129 views1 answer
Mysql best tutorial for beginners
SQL
0 vote131 views1 answer
Désinstaller postgresql linux
SQL
0 vote121 views1 answer
Running query in redshift
SQL
0 vote139 views1 answer
Sql dmv to capture updates
SQL
24 votes158 views4 answers
Delete db postgres
SQL