Answers for "max 5 in sql"

SQL
6

sql display max value

SELECT MAX(<numeric column>) FROM <table>;
SELECT MAX(<numeric column>) FROM <table> GROUP BY <other column>;
Posted by: Guest on April-01-2020
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