常用的sql 收集

1. 删除重复数据只保留创建时间最小的记录

WITH CTE AS (
    SELECT 
        Id, -- 主键或唯一标识列
        Subject,
        CreateTime,
        RN = ROW_NUMBER() OVER (
            PARTITION BY Subject 
            ORDER BY CreateTime ASC
        )
    FROM YourTable
)
DELETE FROM CTE WHERE RN > 1;