基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

--查询重复数据方法一
select COUNT(*) from HB_BORROWER_INFORMATION a
where (a.APPLICATION_CODE) in  (
select APPLICATION_CODE from HB_BORROWER_INFORMATION group by APPLICATION_CODE
having
count(*) > 1)
and rowid not in (select min(rowid) from HB_BORROWER_INFORMATION group by APPLICATION_CODE having count(*)>1)

--查询重复数据方法二
SELECT
	ROWID,
	a.BORROWER_NO
FROM
	HB_PLATFORM_CUSTOMER a
WHERE
	a.rowid !=(
		SELECT
			MAX( ROWID )
		FROM
			HB_PLATFORM_CUSTOMER b
		WHERE
			a.BORROWER_NO = b.BORROWER_NO
	);

--删除重复
DELETE 
from MCG_FLOW_TRANSACTION WHERE (ORDER_CODE) IN ( SELECT ORDER_CODE FROM MCG_FLOW_TRANSACTION GROUP BY ORDER_CODE HAVING COUNT(ORDER_CODE) > 1) AND 
ROWID NOT IN (SELECT MIN(ROWID) FROM MCG_FLOW_TRANSACTION GROUP BY ORDER_CODE HAVING COUNT(*) > 
1);

--查询重复数据方法二	
SELECT * FROM (
		        SELECT
		            ROW_NUMBER() OVER(
		                PARTITION BY  a.BID_ID  ORDER BY a.LOAN_DATE DESC) rn,
		            a.*
		        FROM
		            HB_BORROWER_INFORMATION_NU a
		            )
		       WHERE rn>1