/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 vote237 views1 answer
Openquery join two tables
SQL
2 votes223 views2 answers
Sql query to list all tables in a database sql server
SQL
1 vote233 views1 answer
Mysql select update same table
SQL
0 vote188 views1 answer
Mysql count by month
SQL
0 vote199 views1 answer
How to get one year old query from plan cache
SQL
0 vote237 views1 answer
Take sql dump in to file
SQL
1 vote210 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote218 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote199 views1 answer
Sql developer connect to sql server
SQL
0 vote187 views1 answer
Fill up postgres db
SQL