SQL query: using MAX and GROUP BY with other fields - Databases - SitePoint Forums | Web Development & Design Community

Given these entries in my table: id date value 4 2002-1-1 zero 4 2002-2-26 first 4 2002-2-28 second I am trying to write a SQL query to get the value at the maximum date. So I first tried this query and got: s…