How to remove duplicates from Taleo Webservice export

Summary:

TCC export data is showing duplicates. Webservice export with same query is throwing error.

Content (please ensure you mask any confidential information):

TCC export data is showing duplicates. Webservice export with same query is throwing error as

"<faultstring>An error occurred during the query execution: The element id must refer to the same element as the current result set row. Element id=24966565; Current result set row=24987636. Maybe you have duplicates in the id query because your query navigates a collection in a filtering or a sorting. Maybe you have a projection filtering or an inner join that filters out a root element that was returned in the id query.</faultstring>".