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

1 vote109 views1 answer
Avg mysql
SQL
0 vote121 views1 answer
Acual month sql
SQL
0 vote136 views2 answers
Change database postgres
SQL
-1 vote148 views1 answer
Mysql delete duplicate rows except one
SQL
1 vote154 views1 answer
Mysql previous year
SQL
-1 vote165 views4 answers
Full outer join in sql
SQL
0 vote134 views1 answer
Insert using condition postgres
SQL
1 vote134 views2 answers
Sql server concat string and int
SQL
0 vote141 views2 answers
How to install mssql on mac
SQL
0 vote124 views1 answer
T-sql conditional order by multiple columns
SQL