ho potuto provarlo solo oggi
occorre modificarlo in:

select data, count(*) as quanti from tabella group by data having count(*)>1 order by data

grazie mille