![](https://desk.zoho.com/galleryDocuments/edbsna92a93005d5e70b668375ee5c5d6e79aab057dd1b1e7ebed358a004711618ec5b0ec8d44d8ac86fd31fe2cf7953c127f?inline=true)
Step-4: Run a qery to get duplicate activities.
Open an SQL Console and paste the following query: SELECT ACTIVITY_ID FROM USR_BOKFEKW1UQIR49ZB0UMWNTMFE.TAE_ACTIVITY WHERE TURNAROUND_ID =
'6d32f860-c786-4fc4-9053-8dff9568ea7a' AND DELETED = 0 GROUP BY ACTIVITY_ID HAVING COUNT(ACTIVITY_ID) > 1;
Replace the text in red with the copied TURNAROUND_ID.
Click run and you should see the activities that are duplicated for that Turnaround.
Step-5: Delete/Change them one-by-one.
Open the Table TAE_ACTIVITY and Open Data and paste a selected activity id in the Search, it should display all the duplicated copies.
To Delete: To delete an activity set the deleted to 1 by clicking once in the cell to enter edit mode and set it to 1 and hit save.
![](https://desk.zoho.com/galleryDocuments/edbsnff9c00656e809e13052c95753d9313670901876503c208604687f40a9e733f0ee2ba374e1850e65392295204b67dc86a?inline=true)
To Keep Both Activities: Again enter edit mode this time on the ACTIVITY_ID column and change a number the id ranges from 1-9 and a-e. Hit save to save the new activity id.
Step-6: Run the same query to verify all duplicates have been deleted/changed.
From the SQL Console execute the same query and verify that this time there are 0 rows in the output.