How to SELECT by MAX(date)?

by

This should do it:

SELECT report_id, computer_id, date_entered
FROM reports AS a
WHERE date_entered = (
    SELECT MAX(date_entered)
    FROM reports AS b
    WHERE a.report_id = b.report_id
      AND a.computer_id = b.computer_id
)

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. What is better subquery vs literal on IN clause in mysql
  3. Calculate Average of the largest values in multiple columns
  4. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  5. SQL query return data from multiple tables
  6. quick selection of a random row from a large table in mysql
  7. MySQL SELECT only not null values
  8. Ordering by specific field value first
  9. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  10. SQL Query to get column values that correspond with MAX value of another column?
  11. Checking multiple columns for one value
  12. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  13. MySQL INSERT INTO … VALUES and SELECT
  14. MySQL error 1241: Operand should contain 1 column(s)
  15. How to select one row randomly taking into account a weight?
  16. quick selection of a random row from a large table in mysql
  17. Compare only day and month with date field in mysql
  18. Syntax error when using except in a query
  19. SELECT query return 1 row from each group
  20. MySQL INNER JOIN select only one row from second table
  21. MySQL Select Query – Get only first 10 characters of a value
  22. SQL query to check if a name begins and ends with a vowel
  23. Deleting a row based on the max value
  24. 1052: Column ‘id’ in field list is ambiguous
  25. Cumulative sum over a set of rows in mysql
  26. Set NOW() as Default Value for datetime datatype?
  27. Add Auto-Increment ID to existing table?
  28. MySQL SELECT DISTINCT multiple columns
  29. SQL DELETE with JOIN another table for WHERE condition
  30. How do I get the first day of the week of a date in mysql?

Leave a Comment