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

2 votes109 views4 answers
Check timezone of mysql database
SQL
1 vote111 views2 answers
Populate sql table with random data
SQL
6 votes117 views2 answers
Join vs union
SQL
0 vote110 views1 answer
PostgreSQL types and C# types
SQL
0 vote106 views1 answer
Why we have to set the password for my sql server
SQL
0 vote111 views1 answer
Display first three characters sql
SQL
1 vote131 views2 answers
Mysql add column tinyint default 0
SQL
5 votes119 views2 answers
Ranking functions in sql
SQL
1 vote106 views1 answer
Postgresql convert text to float
SQL
1 vote111 views1 answer
Mysql select utc time in eastern time
SQL