Delete duplicate fields

[cleberzumba]

Personal as I do to delete the duplicate records getting only one, I delete a record and the copy is. Being that even the id are the same.

[Dulima-SP]

The ids do not have index unique ????

Do you have any unique key in the table ???
How did you duplicate these fields ??

[cleberzumba]

It was not me who inserted, I already got it. There is nothing different, nothing at all.

[gokden]

Dude, yes, yes ... pear a pouco qui já I'll show you how = D

[cleberzumba]

Beauty, I'm waiting.



: -O

[gokden]

Dude ... I liked this doubt and I was testing everything I knew and made this SQL Bloquinhu deletes the duplicate lines, oia chi legal ...

Select all

DECLARE 
   cursor c_1 is 
      select rowid 
           , row_number() OVER (Partition by numero order by numero) linha 
        from lucasq; 
BEGIN 
   for reg in c_1 
   loop 
      delete from lucasq where reg.linha > 1 and rowid = reg.rowid; 
   end loop; 
END;

Details From the LUCASQ table:

Select all

 
NUMERO                    LETRA 
-------------------- ---------- 
123                         123 
123                         123 
123                         123 
124                         124 
124                         124 
124                         124

[cleberzumba]

Thanks my comrade, thanks.