风之语者

摘要： 原始数据:Table1ID Name-----------------------1 a 2 b3 a4 c5 b需要数据:Table1ID Name-----------------------1 a 2 b4 c开始:DELETE FROM TABLE1 WHERE ID IN (SELECT ID FROM (SELECT ID, RANK OVER(PARTRITION BY NAME ORDER BY ID) AS RankNumberFROM TABLE1WHERE RankNumber<>1) -- 根据name分组,在组内设置等级编号,保留第一条,其他删掉)该SQL 阅读全文