delete all duplicate records and leave only the occurrence of first record
Hi, can you help me with that
I need to find easy way to delete all duplicate records and leave only the occurrence of first record.
SQL>select kod,street from kancel;
KOD_OBL1 STREET
---------- ----------
108 28. ?mjna
110 Jesenicka
111 Gen. Hla?o
111 ?tefanikov
112 Mendelova
113 Hlavnm 77
114 Radni?nm 1
114 Hlavnm 148
114 8. p??mho
115 ?erotmnovo
116 Radni?nm 1
I want to delete all records wich are duplicate (but not the first occurrence, where must be stay). it means after deletion the select will fetch the data like this:
KOD_OBL1 STREET
---------- ----------
108 28. ?mjna
110 Jesenicka
111 Gen. Hla?o
112 Mendelova
113 Hlavnm 77
114 Radni?nm 1
115 ?erotmnovo
116 Radni?nm 1
thank you very much.