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 vote224 views2 answers
Greater than sql server
SQL
16 votes233 views3 answers
T-SQL Add Column
SQL
0 vote201 views3 answers
Run sql command line
SQL
2 votes192 views1 answer
Username sql
SQL
0 vote265 views1 answer
Python get backup of sql
SQL
0 vote182 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote194 views1 answer
Mysql wsrep ls
SQL
0 vote203 views1 answer
Alter table engine mysql
SQL
1 vote184 views1 answer
Mysql random limit 1
SQL
0 vote194 views1 answer
Mysql enter ubuntu
SQL