mysql MAX-GROUP BY

[admin]

I am trying to get the folowing sql statement to return only the max date for each of the types.

As you can it returns the same type twice.


select Type, MAX(Datex) as maxDatex from tblResponses
where Type like 'QAC%'
group by Datex,Type
order by Datex Desc

Results
TYPE Datex
QAC Azo-Brader 05/30/2001
QACP 05/30/2001
QAC Azo-Brader 05/29/2001