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

6 votes169 views1 answer
Identify primary key in oracle table
SQL
2 votes164 views2 answers
Change mysql password from command line
SQL
2 votes142 views2 answers
Change varchar length mysql
SQL
0 vote140 views1 answer
Mysql workbench indent formatting
SQL
36 votes166 views3 answers
Add column in mysq
SQL
0 vote165 views1 answer
Play framework connection via windows sql server
SQL
1 vote317 views1 answer
Postgres convert text to number
SQL
24 votes168 views5 answers
List mysql users
SQL
0 vote146 views1 answer
Wordpress database query change url
SQL
3 votes148 views3 answers
Into in sql
SQL