/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

16 votes147 views1 answer
Sqlserver add column to table
SQL
2 votes157 views1 answer
Sql server check for value in multiple columns
SQL
0 vote164 views1 answer
Php select data from mysql database without column name
SQL
0 vote181 views1 answer
Postgres row expiration
SQL
0 vote133 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
1 vote129 views3 answers
Grant syntax in sql
SQL
0 vote167 views1 answer
Sql server current time without date
SQL
0 vote148 views1 answer
List all permissions on a table in postgres
SQL
4 votes160 views2 answers
REST API
SQL
0 vote136 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL