How can I find duplicate data with serverconnect

I want to list duplicate data via serverconnect then I want to delete them …

How can I create this query via serverconnect query builder ?

SELECT id,
    data_datalar.`data`, COUNT(data_datalar.`data`)
FROM
    data_datalar
GROUP BY data_datalar.`data`
HAVING COUNT(data_datalar.`data`) > 1;
Community Page
Last updated: