sqlserver 2008 R2 删除重复数据
来源:互联网 发布:手机淘宝无线端链接 编辑:程序博客网 时间:2024/06/05 00:13
推荐方法3
--方法1:
SELECT *
FROM ( SELECT Row_Number() OVER ( PARTITION BY [orderno] ORDER BY ( SELECT
0
) ) AS RowNO ,
*
FROM tblMulCharge
) t
WHERE T.RowNO > 1 ;
--方法2:
WITH ct01
AS ( SELECT ROW_NUMBER() OVER ( PARTITION BY orderno ORDER BY ( SELECT
0
) ) AS rn
FROM tblMulCharge
)
DELETE FROM ct01
WHERE rn > 1
go
--方法3:针对大数据
WITH ct01
AS ( SELECT [ID] ,
[OriOrderNo] ,
[OrderNo] ,
[TotalAmount] ,
[PayAmount] ,
[ProviderAmount] ,
[transaction_id] ,
[PNRCode] ,
[Consumer] ,
[Provider] ,
[SellerAccount] ,
[BuyerAccount] ,
[State] ,
[PayTime] ,
[PayInfo] ,
[RefundTime] ,
[refund_id] ,
[refund_info] ,
[RefundTimeV] ,
[refund_id_V] ,
[refund_info_V] ,
[RefundAmount] ,
ROW_NUMBER() OVER ( PARTITION BY orderno ORDER BY ( SELECT
0
) ) AS rn
FROM tblMulCharge
)
SELECT
[ID]
,[OriOrderNo]
,[OrderNo]
,[TotalAmount]
,[PayAmount]
,[ProviderAmount]
,[transaction_id]
,[PNRCode]
,[Consumer]
,[Provider]
,[SellerAccount]
,[BuyerAccount]
,[State]
,[PayTime]
,[PayInfo]
,[RefundTime]
,[refund_id]
,[refund_info]
,[RefundTimeV]
,[refund_id_V]
,[refund_info_V]
,[RefundAmount]
INTO dbo.tblMulCharge_tmp
FROM ct01
WHERE rn = 1
DROP TABLE dbo.tblMulCharge ;
EXEC sp_rename 'dbo.tblMulCharge_tmp', 'tblMulCharge'
- sqlserver 2008 R2 删除重复数据
- sqlserver 2008R2 删除一个表中的重复数据
- SQLServer删除重复数据记录
- SqlServer怎么删除重复数据
- Sqlserver 2008R2 删除日志文件
- ORACLE,SQLSERVER,DB2 删除重复数据SQL
- SQLserver 查看表详细信息--删除重复数据
- SQLSERVER删除表内重复数据
- SQLServer 删除表中的重复数据
- SQLServer 2008 R2删除登录名时报如下错误
- SQLSERVER 删除重复记录
- SQLServer中删除重复数据的几个方法
- 几种在SQLServer中删除重复数据方法
- sqlserver中多行所有数据重复,无法更新或删除问题
- sqlserver中如何删除没有主键的重复数据。
- sqlserver sql 对重复数据的操作 查找 删除
- SQLServer-----SQLServer 2008 R2安装
- SQLServer-----SQLServer 2008 R2卸载
- Spring在web应用中获得Bean的方法
- C#3.5新增的Expression来提升反射性能
- 国内云计算发展的五个特点
- 用Jdk自带工具keytool生成受信任的证书
- 方法的直接调用,反射调用与……Lambda表达式调用
- sqlserver 2008 R2 删除重复数据
- 餐桌上的“爱心菜”
- 全球级的分布式数据库 Google Spanner原理
- 如何高效、可移植申请内存代码。
- Ireport-jfreechart多报表同时打印
- 数据库事务和范式
- AnchorPoint And Position 对比及区别
- CMM/ISO/CMMI
- WinCE下电池充放电测试