Delete Duplicate Records from Access Table

[siddharthsindhwani]

Hi Nishun,

I used your SQL statement but it gives only records which are not repeating. So in the below example we are only left with col2 and col3 values.

I am assuming that count function will give 2 for both col1 values hence will not pass them in new table. We should have a way to get atleast one col1 in the new table.

Thanks
Sidd