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 vote195 views1 answer
Postgresql replace html tags from string
SQL
11 votes190 views6 answers
Distinct sql
SQL
3 votes213 views1 answer
Oracle cannot access v$session
SQL
0 vote248 views1 answer
Show all mongodb
SQL
2 votes212 views2 answers
Calculate percentage in sql
SQL
0 vote190 views1 answer
Mysql date format unix timestamp
SQL
0 vote183 views1 answer
How to make case insensitive in sql
SQL
0 vote183 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote207 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote151 views1 answer
Mysql insert with foreign key
SQL