AW: [php] group by soll duplikate finden

[php_(at)_phpcenter.de]

> >SELECT *,COUNT(id) AS num_items
> >FROM main
> >WHERE num_items > 1
> >GROUP BY song_length DESC

probiers mal hiermit:

select *,count(id) as num_items from main group by song_length having
num_items > 1