MYSQL e select distinct

[optime]

select data, fascia, classe, MAX(cognome), MAX(nome), MAX(varie) from registro where anno='2013' GROUP BY data, fascia, classe