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 votes259 views1 answer
Sql ends with string
SQL
0 vote288 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote296 views1 answer
Get total and distict row diff in sql
SQL
0 vote300 views1 answer
Snowflake drop column
SQL
0 vote423 views1 answer
Dublicate row sql
SQL
1 vote239 views1 answer
Import database from a file using mysql commandline
SQL
0 vote274 views1 answer
How to write if case in select query in select statement
SQL
4 votes250 views1 answer
Oracle table statistics last analyzed
SQL
0 vote252 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote284 views1 answer
T-sql update table variale
SQL