> > Hello! > > > > I am looking for an easy solution for eliminate duplicates but on a row > > level. > > > > I am having 2 tables. 1 destination for all not duplicated info (a) > > and 1 for input table (b) which might have duplicates related to table > > a. Now I am using this kind of insert: > > > > INSERT INTO a > > SELECT fields > > FROM b > > WHERE ... NOT EXISTS ( > > SELECT * FROM a WHERE (a.a,a.b,a.c,a.d)=(b.a,b.b,b.c,b.d) > > ) > > > > Looks like it works but is it any solution for row level compare > > without naming all fields? For example WHERE (a.*) = (b.*) instead of > > currently used (a.a,a.b,...)=(b.a,b.b,...).
Have you tried create table B as select * from A where 1 group by 'index';