情况是这样的，有的数据是两条一样的数据但是isdel和vesion是不一样的，所以现在要求数据库里只存在一条数据，用了having一查有5397条重复的数据，量太大了，所以进行清洗数据，如下操作

情况是这样的，有的数据是两条一样的数据但是isdel和vesion还有gmt_modified是不一样的，所以现在要求数据库里只存在一条数据，用了having一查有5397条重复的数据，量太大了，所以进行清洗数据，下面是mysql 的语法，如下操作
CREATE DEFINER=root@% PROCEDURE tempProcedure()
BEGIN
DECLARE count int(20);
DECLARE ind int(20);
DECLARE lastOrderId bigint(11) unsigned;
DECLARE currOrderId varchar(300) ;
DECLARE deleteId bigint(11);
declare cursorForDel cursor for (select receipt_no,max(gmt_modified) from t_erp_receipt group by receipt_no having count(receipt_no)>1);
set ind = 0;
set count = 0;
– select count from dual; --打印总条数
open cursorForDel;
loop – mysql有三种循环：while，repeat，loop
fetch cursorForDel into deleteId, currOrderId;

	  delete from t_erp_receipt where receipt_no=deleteId and gmt_modified != currOrderId;

– select deleteId,lastOrderId – 输出当前获取到的id与order_id
set ind = ind+1;
end loop;
close cursorForDel;
END
下面是pqsql的语法

CREATE OR REPLACE PROCEDURE "public"."tempprocedure"()
 AS $BODY$BEGIN
DECLARE
    -- 声明变量
    currOrderId VARCHAR(500);
    deleteId INT8;
    supplierNumber VARCHAR(80);
    supplierId VARCHAR(80);

BEGIN
    -- 循环查询结果
    FOR currOrderId, deleteId IN
        SELECT
            description,
            MAX(ID) AS maxId -- 为MAX(ID)指定别名
        FROM
            basic_part
        GROUP BY
            description
        HAVING
            COUNT(*) > 1
    LOOP
        -- 删除重复的记录
        DELETE FROM basic_part WHERE id = deleteId;
        -- 可选：输出当前删除的ID和订单ID
        -- RAISE NOTICE 'Deleted ID: %, Order ID: %', deleteId, currOrderId;
    END LOOP;
END;
END$BODY$
  LANGUAGE plpgsql