Java教程

数据库多字段去重

本文主要是介绍数据库多字段去重,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

# 查询

SELECT
	*
FROM
	shopee_finance_data_statistics_v2 a
WHERE
	(
		a.get_time,
		a.realname,
		a.payout_time
	) IN (
		SELECT
			get_time,
			realname,
			payout_time
		FROM
			shopee_finance_data_statistics_v2
		GROUP BY
			get_time,
			realname,
			payout_time
		HAVING
			count(*) > 1)

  

 

# 删除

DELETE
FROM
	shopee_finance_data_statistics_v2
WHERE
	id IN (
		SELECT
			id
		FROM
			(
				SELECT
					id
				FROM
					shopee_finance_data_statistics_v2 a
				WHERE
					(
						a.get_time,
						a.realname,
						a.payout_time
					) IN (
						SELECT
							get_time,
							realname,
							payout_time
						FROM
							shopee_finance_data_statistics_v2
						GROUP BY
							get_time,
							realname,
							payout_time
						HAVING
							count(*) > 1
					)
				AND id NOT IN (
					SELECT
						min(id)
					FROM
						shopee_finance_data_statistics_v2
					GROUP BY
						get_time,
						realname,
						payout_time
					HAVING
						count(*) > 1
				)
			) AS tmptb
	)

  

这篇关于数据库多字段去重的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!