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 vote81 views1 answer
Mysql select top 2
SQL
0 vote115 views1 answer
Sub query in linq
SQL
0 vote111 views1 answer
Mysql auto increment default value with prefix month and year
SQL
1 vote119 views1 answer
Count of tables in database mysql
SQL
0 vote126 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote109 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
1 vote154 views2 answers
Sql split string by space
SQL
0 vote112 views1 answer
Oracle grant create job
SQL
0 vote107 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
0 vote129 views1 answer
Sqlite trim
SQL