How to SELECT by MAX(date)?

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
)

Related Contents:

  1. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  2. SQL query return data from multiple tables
  3. quick selection of a random row from a large table in mysql
  4. MySQL SELECT only not null values
  5. Ordering by specific field value first
  6. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  7. Syntax error when using except in a query
  8. SQL Query to get column values that correspond with MAX value of another column?
  9. SELECT query return 1 row from each group
  10. Checking multiple columns for one value
  11. MySQL INNER JOIN select only one row from second table
  12. MySQL – How to search for exact word match using LIKE?
  13. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  14. SQL query to check if a name begins and ends with a vowel
  15. MySQL Select Query – Get only first 10 characters of a value
  16. MySQL INSERT INTO … VALUES and SELECT
  17. How to select one row randomly taking into account a weight?
  18. quick selection of a random row from a large table in mysql
  19. Compare only day and month with date field in mysql
  20. Retrieving the last record in each group – MySQL
  21. Calculate a running total in MySQL
  22. SELECTING with multiple WHERE conditions on same column
  23. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  24. Simulate lag function in MySQL
  25. Calculate Age in MySQL (InnoDb)
  26. Cast from VARCHAR to INT – MySQL
  27. Select row with most recent date per user
  28. difference between primary key and unique key
  29. Mixing ANSI 1992 JOINs and COMMAs in a query
  30. SQL: Creating a Relational table with 2 different auto_increment
  31. How do I select an entire row which has the largest ID in the table?
  32. How to count items in comma separated list MySQL
  33. Entity-Attribute-Value Table Design
  34. The total number of locks exceeds the lock table size
  35. Can I reuse a calculated field in a SELECT query?
  36. MySQL create stored procedure syntax with delimiter
  37. MySQL : transaction within a stored procedure
  38. Deleting duplicate rows from a table
  39. Determine Rank based on Multiple Columns in MySQL
  40. Cast int to varchar
  41. View’s SELECT contains a subquery in the FROM clause
  42. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  43. mysql trigger stored trigger is already used by statement which invoked stored trigger
  44. How does MySQL’s ORDER BY RAND() work?
  45. MySQL combine two columns and add into a new column
  46. Calculating time difference between 2 dates in minutes
  47. Return a default value if single row is not found
  48. How to get multiple records against one record based on relation?
  49. sql like operator on integer
  50. MySQL – SELECT all columns WHERE one column is DISTINCT

Leave a Comment