get max date with id in sql code example

Example: where date = max(date) in sql

SELECT report_id, computer_id, date_entered
FROM reports AS a
WHERE date_entered = ( SELECT MAX(date_entered) FROM reports );