2025年8月8日
删除重复记录，保留一条
摘要： DELETE FROM 表名WHERE ROWID IN ( SELECT rid FROM ( SELECT ROWID AS rid, ROW_NUMBER() OVER (PARTITION BY bid ORDER BY create_time DESC) AS rn -- 按时间倒序 FR 阅读全文
posted @ 2025-08-08 17:15 Tab_to 阅读(32) 评论(0) 推荐(0)