Hi I'm a newbie here. I'm hoping someone can help me..

Here is the scenario:
I have a bunch of duplicate records I need to clean up
This query below will help me identify the list of duplicate records.

select * from Tablename
where acctdebitid like '57%' and status = 'WILLPROCESSON'
and datecreate like '2006/01/13%'
order by customerid, id, listid, date

All the columns...