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

3 votes175 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote180 views1 answer
Mysql streaming example
SQL
7 votes199 views5 answers
Max 3 salary in sql
SQL
0 vote200 views1 answer
Sql date time query find
SQL
3 votes181 views5 answers
Mysql get last inserted id
SQL
3 votes176 views2 answers
Brew start mysql
SQL
0 vote248 views1 answer
How do you insert boolean to postgresql
SQL
0 vote173 views1 answer
What is between operator
SQL
0 vote182 views1 answer
How to use query in nosql
SQL
32 votes177 views6 answers
Insert select
SQL