/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 vote310 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote314 views1 answer
Mysql limit order by
SQL
5 votes278 views1 answer
Oracle ora-00054 causes
SQL
1 vote278 views1 answer
Sql get missing id
SQL
1 vote292 views1 answer
Importance of comment in mysql
SQL
1 vote299 views1 answer
Use of now() in mysql
SQL
5 votes280 views2 answers
Update all rows mysql
SQL
1 vote293 views1 answer
Sql in array query
SQL
0 vote305 views1 answer
To_date sql
SQL
15 votes310 views5 answers
Show tables in oracle
SQL