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:
Last updated: