Min and max salary and name in sql

SELECT FIRST_NAME , SALARY
FROM EMPLOYEES
WHERE SALARY IN (SELECT MAX(SALARY)AS RESULT FROM EMPLOYEES
UNION
SELECT MIN(SALARY)AS RESULT FROM EMPLOYEES);

Similar codes

0 vote142 views1 answer
Mysql update from n to 100
SQL
0 vote141 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote141 views1 answer
Describe in sqlite3
SQL
0 vote130 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
1 vote1.8K views1 answer
Dropping a constraint in ms sql
SQL
10 votes153 views1 answer
All_dependencies
SQL
0 vote131 views1 answer
What is initial catalog in sql connection string
SQL
0 vote172 views1 answer
Provera dupliranih konatakata
SQL
3 votes146 views1 answer
V$session not found in oracle
SQL
0 vote283 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL