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 vote275 views1 answer
Top 10 rows in mysql
SQL
-1 vote269 views1 answer
Ssql to lowercqse
SQL
1 vote259 views1 answer
Varchar plsql
SQL
3 votes252 views4 answers
Show sql server database
SQL
3 votes289 views2 answers
Postgres inner join vs join
SQL
0 vote237 views1 answer
Print sum of values sql
SQL
0 vote302 views1 answer
Create table split string function in sql server
SQL
0 vote270 views1 answer
Postgresql find missing id
SQL
28 votes237 views6 answers
Distinct sql
SQL
0 vote283 views1 answer
Get all employee of salary if more than in sql
SQL