MySQL清理多余数据保留一条

DELETE FROM table
WHERE EXISTS(
    SELECT * FROM (
                    SELECT MAX(uids) uids,time_period,version_id,ele_power_no FROM table
                    GROUP BY time_period,version_id,ele_power_no
                    HAVING COUNT(1)>1) T
    WHERE table.time_period=T.time_period
      AND table.version_id=T.version_id
      AND table.ele_power_no=T.ele_power_no
      AND table.uids<T.uids
)

mysql清理多余数据保留一条