How to SELECT by MAX(date)? How to SELECT by MAX(date)? mysql mysql

How to SELECT by MAX(date)?


mysql sql select max

This should do it:

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

mysql sql select max

Are you only wanting it to show the last date_entered, or to order by starting with the last_date entered?

SELECT report_id, computer_id, date_enteredFROM reportsGROUP BY computer_idORDER BY date_entered DESC-- LIMIT 1 -- uncomment to only show the last date.

mysql sql select max

Accordig to this: https://bugs.mysql.com/bug.php?id=54784 casting as char should do the trick:

SELECT report_id, computer_id, MAX(CAST(date_entered AS CHAR))FROM reportsGROUP BY report_id, computer_id

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last