/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

57 votes327 views6 answers
Sql alter table
SQL
13 votes130 views5 answers
Alter table query sql server change column
SQL
0 vote157 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
11 votes145 views4 answers
Update row in mysql
SQL
3 votes174 views1 answer
Oracle nextval insert
SQL
0 vote138 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote163 views1 answer
Primary key start from number
SQL
-1 vote148 views2 answers
Installing mysql on centos 7
SQL
0 vote147 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote138 views1 answer
Access mysql database docker container shell
SQL