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 vote238 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote219 views1 answer
Mysql into outfile with headers
SQL
0 vote248 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote235 views1 answer
Sort by
SQL
0 vote235 views1 answer
Mysql enter ubuntu
SQL
2 votes236 views1 answer
Oracle apex who is connected
SQL
10 votes280 views4 answers
Join multiple tables in sql
SQL
1 vote254 views1 answer
Sqlalchemy on delete set null
SQL
0 vote298 views1 answer
Python get backup of sql
SQL
0 vote232 views1 answer
Mysql in clausule string array
SQL