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 vote166 views1 answer
Mysql export and import
SQL
57 votes545 views6 answers
Mysql alter table add column
SQL
3 votes175 views2 answers
Oracle for loop
SQL
13 votes173 views6 answers
Current date sql
SQL
0 vote210 views1 answer
Sql multiple into
SQL
0 vote217 views1 answer
Sql cheetsheet
SQL
0 vote193 views1 answer
Sql query wordpress export post
SQL
1 vote163 views1 answer
How refresh navicat tables to see new tables
SQL
1 vote254 views1 answer
Sql server read uncommitted
SQL
0 vote166 views1 answer
SQL column name Oracle
SQL