06 2011 档案

删除数据库中重复的记录
摘要：查询重复列：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 阅读全文
posted @ 2011-06-29 13:45 Xingsoft 阅读(186) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示