sql update with max date 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 );
SELECT report_id, computer_id, date_entered
FROM reports AS a
WHERE date_entered = ( SELECT MAX(date_entered) FROM reports );