Select And Display The Max Value From A Group In Sql?

hi

i have a database that has multiple records under the same id (each time a record is updated, it's assigned a date_value), i'm wanting one row to be generated using the data from the most recent date_value field.

a sample of the database looks something like this:

ID  date_value  data
1   24 march    info1
1   25 march    info2

my statement looks like this:

select max(date_value), data
from table_name
where data is not null 
group by id

this seems to bring up the following error for all the fields not in the group by part of the code:
Column 'COLUMN_NAME' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

 what am i doing wrong?

TIA!