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

1 vote209 views1 answer
Update and replace mysql
SQL
2 votes220 views1 answer
Oracle kill job by sid
SQL
3 votes223 views4 answers
Stop MySQL
SQL
0 vote222 views1 answer
Mysql error 1251
SQL
0 vote206 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote239 views1 answer
Oracle current date minus 1 day
SQL
1 vote200 views1 answer
Sql get all columns from one table but one from another inner join
SQL
1 vote220 views2 answers
Sql multiline comment
SQL
2 votes225 views1 answer
Where clause for child record apex
SQL
0 vote174 views1 answer
Import csv to mysql
SQL