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 vote118 views1 answer
Postgres truncate with cascade
SQL
1 vote117 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
10 votes187 views2 answers
Doublon sql
SQL
4 votes81 views2 answers
Select todays data postgres query
SQL
-1 vote108 views1 answer
How to use update trigger in sql
SQL
4 votes132 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote131 views1 answer
Select odd records sql
SQL
8 votes102 views3 answers
Duplicate entry
SQL
0 vote108 views1 answer
Remove binlog mysql
SQL
3 votes119 views3 answers
Stop mysql ubuntu
SQL