SQLite’s goal

1) Find the duplicate records and classify them into a new table. max(id) is the record you want to delete

create table ttt as select gallery_url ,max(id) as< /span> theid from gallery group