摘要: 利用row_number函数处理重复数据--创建测试表personCREATE TABLE person( sn varchar(10), name varchar(50));go--插入测试重复数据insert into person values('1','guoqiang1');insert into person values('1','guoqiang1');insert into person values('1','guoqiang1');insert into person valu 阅读全文
posted @ 2008-02-18 13:00 深潭 阅读(675) 评论(0) 推荐(0) 编辑