select col1, col2, col3, col4 from table name where (select date_field from table_name where Date_field=Max(date_field))
order by col1...