How to remove duplicate records in a table

[HarshithaNaidu]

How to remove duplicate records in a table 

[Dr Atul G- LNG]

Hi @HarshithaNaidu 

What is an identifier to find ut a record is duplicate? and record mean foundation data or transactional data? Need more details to guide you mate.

[Ankur Bawiskar]

@HarshithaNaidu 

you need to know why there are duplicates.

what's the source of data for that table?

to find the duplicates check this

Get Duplicate Records from any table 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[HarshithaNaidu]

Thank you for your response @Ankur Bawiskar  .The duplicates in my table were created due to importing a set, updating a few things, and then importing the set again. I would like to keep only the updated records. Is there any way to achieve this through ServiceNow's built-in features or other non-scripting methods?
Thank you for your help.

[Dr Atul G- LNG]

Hi @HarshithaNaidu 

So now, you need to find out the identifier, Maybe you can take the updated or created time when the 2nd time is imported? You can select from the list view by checking box and then in the list action click on delete and it will be done without coding.