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 vote169 views1 answer
Operator does not exist: integer = text
SQL
1 vote160 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote181 views1 answer
Oracle string substitution
SQL
0 vote178 views1 answer
Mysql regex select
SQL
2 votes179 views2 answers
Mysql count rows returned
SQL
0 vote212 views1 answer
Example of sql querry result sepapreted by comma
SQL
1 vote240 views1 answer
Show databases mysql docker
SQL
0 vote196 views1 answer
Mysql workbench not showing schemas
SQL
1 vote182 views2 answers
Mysql insert generate serie
SQL
0 vote197 views1 answer
Set root password mysql xampp
SQL