|Subject||Re: How to count duplicate rows using SQL|
> How to count duplicate rows using SQL ? I must localize duplicateSELECT <ID>, COUNT(*)
> rows in my (possibly corupted ) database and delete unnecessary.
GROUP BY <ID>
HAVING COUNT(*) > 1
or something similar I think.
> How often Firebird could cause index to be corrupted due toI don't know, but it shouldn't happen often unless you do something
> duplicate rows and why ?
strange like having forced writes off or handling its uniqueness
yourself rather than take advantage of primary keys and unique