> 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
HAVING COUNT(*)>1

Pepak