Re: Query duplicate rows

[Peter Brawley]

select col1, col2, ..., colN, count(*) as N
from tbl
group by col1, col2, ..., colN
having N>1;