数据库的重复行怎么删除
group by 几个关键字，having count>1，然后select 几个关键字，如果id不重复可以直接拿到id，如果id重复，就那数据库自己生成的row_id，根据id或者row_id删除数据
WITH ct
AS
(
SELECT *,ROW_NUMBER() OVER(PARTITION BY id ORDER BY id ) AS x FROM 学生表
)
DELETE FROM ct WHERE x>1
group by 几个关键字，having count>1，然后select 几个关键字，如果id不重复可以直接拿到id，如果id重复，就那数据库自己生成的row_id，根据id或者row_id删除数据
WITH ct
AS
(
SELECT *,ROW_NUMBER() OVER(PARTITION BY id ORDER BY id ) AS x FROM 学生表
)
DELETE FROM ct WHERE x>1