Answers for "max year in sql"

SQL
1

sql where max date

SELECT report_id, computer_id, date_entered
FROM reports AS a
WHERE date_entered = ( SELECT MAX(date_entered) FROM reports );
Posted by: Guest on July-08-2021
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