Subject Re: [firebird-support] How to find duplicate rows when creating a unique index?
Author Matthias Hanft
Dimitry Sibiryakov schrieb:
>
> select blz, konto, auszugrn, neugutdatum, count(*) from auszuege
> group by blz, konto, auszugrn, neugutdatum
> having count(*)>1

Oh, "having" was the magic word I was trying to find - thank you
very much! I already knew that it exists, but I guess I had used
it just 2 or 3 times within the last 20 years... :-) (never needed
it apparently - until now)

-Matt


[Non-text portions of this message have been removed]