MySql去除重复数据

查询出重复数据

```sql
WITH RANKED_DATA AS (
    SELECT *, 
           ROW_NUMBER() OVER (PARTITION BY LOTTERYDRAWNUM, PRIZELEVEL ORDER BY REPLACE(REPLACE(STAKEAMOUNT,',',''),'---','0') DESC) AS RN
    FROM DA_LE_TOU
) 
SELECT * FROM RANKED_DATA WHERE RN > 1;

删除查询出的重复数据

```sql
DELETE T FROM DLT_DATA T
JOIN (
    SELECT *, 
           ROW_NUMBER() OVER (PARTITION BY LOTTERYDRAWNUM, PRIZELEVEL 
                            ORDER BY CAST(REPLACE(REPLACE(STAKEAMOUNT, ',', ''), '---', '0') AS DECIMAL(20,2)) DESC) AS RN
    FROM DLT_DATA
) RANKED ON T.ID = RANKED.ID
WHERE RANKED.RN > 1;