奇怪的SQL收集

最新推荐文章于 2024-05-02 01:04:40 发布

提枪北上

最新推荐文章于 2024-05-02 01:04:40 发布

阅读量98

点赞数

分类专栏： mysql 文章标签： sql mybatis mysql

本文链接：https://blog.csdn.net/ouxx2009/article/details/127241162

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.根据指定条件，删除重复记录只保留ID最小的一条记录

DELETE 
FROM
	gloria_add_count_view 
WHERE
	id IN (
	SELECT
		id 
	FROM
		(
		SELECT
			id 
		FROM
			gloria_add_count_view 
		WHERE
			skc IN ( SELECT skc FROM gloria_add_count_view WHERE add_order_id = 909 GROUP BY skc HAVING count( skc )> 1 ) 
			AND add_order_id = 909
			AND id NOT IN ( SELECT min( id ) FROM gloria_add_count_view WHERE add_order_id = 909 GROUP BY skc HAVING count( skc )> 1 ) 
		) AS tmpresult 
	)