You could with peek() or previous() check values from former rows against the values from the current row and then set a flag which you could use to filter your data (per selection in gui or per where-clause within the script) - how it works: Peek() or Previous() ?
if(rowno()=1,1, if( previous(Field1)=Field1 and previous(Field2)=Field2 and previous(Field3)=Field3,0,1)) as Flag
order by ID; // Here you have to do order by with key
Drop table Data;
Here, I have taken random 3 fields but in your case you will have all the Fields of that table. So you will have if condition for all the fields of the table
where Flag =1;
drop table New;