oracle765
Starting Member
Australia
13 Posts |
Posted - 03/05/2013 : 16:51:46
|
hi guys I am trying to do a delete to remove duplicate rows but all i want to do is concentrate on the first 3 columns
so if the data in the first 3 columns only match, remove any duplicates, I am not bothered about the rest of the columns in the row being different
Adobe Inc,Version 1.3.1,Licensable,bla,bla,bla,bla Adobe Inc,Version 1.3.1,Licensable,bla,bla,bla,different bla Sun Microsystems, Version 11.3.1,bla,bla,bla,bla Sun Microsystems, Version 11.3.1,bla,bla,bla,bla Sun Microsystems, Version 11.3.1,bla,bla,bla,different bla Sun Microsystems, Version 11.4.1,bla,bla,bla,bla
so it should show
Adobe Inc,Version 1.3.1,Licensable,bla,bla,bla,bla Sun Microsystems, Version 11.3.1,bla,bla,bla,bla Sun Microsystems, Version 11.4.1,bla,bla,bla,bla
A Lynch |
|