Subject Re: [firebird-support] Question : Find duplicated record
Author PenWin
> Some one have an idea how I can find duplicated record into a table?
> I have a record with n fields and one of these, NCOLLO, identify if there
> are duplicated records. Table have no indexes and is popolate from a
> software that I can manage.
> I need to discover duplicated recs and delete them...
> Some ideas?

Not quite sure if this is what you are asking for:

SELECT ncollo
FROM table
GROUP BY ncollo