Answers for "get the max and minin query sql"

SQL
0

sql max min

select emp_name, salary
from employees
where salary = (select max(salary) from employees)
union all
select emp_name, salary
from employees
where salary = (select min(salary) from employees);
Posted by: Guest on November-08-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language