/SQL/FIND OUT THE NAME HIGHEST SALARY SQL

FIND OUT THE NAME HIGHEST SALARY SQL

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT MAX(SALARY) FROM EMPLOYEES);

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
)

Similar codes

0 vote339 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
5 votes290 views1 answer
Minecraft java port number
SQL
0 vote311 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote298 views2 answers
Postgresql gset
SQL
1 vote287 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote287 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
1 vote282 views1 answer
Mysql get latest duplicate rows
SQL
2 votes296 views1 answer
Sql update \
SQL
0 vote289 views1 answer
Sql case sttement with set
SQL
4 votes275 views2 answers
Error loading MySQLdb module.
SQL