摘要：
查询重复列：select * from tb_user where tb_namein (select tb_name from tb_user group by tb_name having count(tb_name)>1)删除数据库中部分字段重复的记录并保留一行。 --创建视图create view v1 asselect *,row_number() over (order by serialcode) as 'id' from TMP_CQ_Cmn_Historywhere starttime in (select starttime from TMP_CQ_C 阅读全文
