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 vote187 views1 answer
Sql date time query find
SQL
1 vote157 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote211 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote142 views1 answer
Hangfire clean script
SQL
4 votes173 views1 answer
Group by mysql and concatenate string
SQL
-2 votes178 views3 answers
Sqlite reset autoincrement
SQL
0 vote169 views1 answer
Postgresql create query
SQL
0 vote209 views1 answer
Postgres truncate with cascade
SQL
6 votes202 views6 answers
Rename column postgres
SQL
2 votes247 views1 answer
How to select from mssql
SQL