Subject | Re: [firebird-support] How to find duplicate rows when creating a unique index? |
---|---|
Author | Matthias Hanft |
Post date | 2009-11-24T11:28:24Z |
Dimitry Sibiryakov schrieb:
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]
>Oh, "having" was the magic word I was trying to find - thank you
> select blz, konto, auszugrn, neugutdatum, count(*) from auszuege
> group by blz, konto, auszugrn, neugutdatum
> having count(*)>1
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]