Finding duplication using sql api

I am trying to first see and count all of my duplicates in an index using sql api and if possible delete it. Looks like DISTINCT, COUNT is not working on my fields since all the fields has a type"text".

COUNT Error: cannot use non-grouped columns , status 400

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.