/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

39 votes174 views4 answers
Select duplicates in sql
SQL
0 vote111 views1 answer
Mysql query to add hours to column in table
SQL
0 vote116 views1 answer
Excel export from sql using python
SQL
-2 votes115 views1 answer
Mysql see users and passwords
SQL
1 vote103 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote114 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote150 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote117 views1 answer
How to insert multiple values in a single column in sql
SQL
1 vote127 views1 answer
Mysql select for update ejemplo
SQL
1 vote114 views1 answer
Oracle case
SQL