Hello All,

Does fragmneted table contain rowids?
If not, how to find the duplicate rows in a table?

I am trying all my ways and nothing is working.

Please help!!


-PD

Hi,

All the rows continene rowid and is not repeated.
In fragmented tables, if it can be repeated, single rowid, not it row. In order to look for duplicated rows rowid executes:
for example select rowid, (primary key),count(*)
from table
group by 1,2
having count(*) > 1

Warning: Informix recommends not to use rowid in fragmented tables.

Gustavo.

Hello Gustavo,

Thank you, so much.
I got it.

-PD