DELETE
FROM
表名
WHERE
rowid NOT IN ( SELECT min( rowid ) FROM 表名 GROUP BY LSH, YYID, SN HAVING count( * ) > 1 )
11-10
1223
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
DELETE
FROM
表名
WHERE
rowid NOT IN ( SELECT min( rowid ) FROM 表名 GROUP BY LSH, YYID, SN HAVING count( * ) > 1 )