MySQL 查询多字段重复数据

最新推荐文章于 2024-04-16 13:41:20 发布

Marttin2

最新推荐文章于 2024-04-16 13:41:20 发布

阅读量2.7k

点赞数 3

分类专栏： sql

本文链接：https://blog.csdn.net/qq_39822451/article/details/108049692

版权

sql 专栏收录该内容

101 篇文章 2 订阅

订阅专栏

			//多字段重复数据
			SELECT
				PUR_ORDER_ID,
				MATERIAL_ID,
				count( * ) 
			FROM
				b_purchase_order_detail 
			GROUP BY
				PUR_ORDER_ID,
				MATERIAL_ID 
			HAVING
				count( * ) > 1;
				
			//查询多字段重复数据	
			SELECT
				* 
			FROM
				b_purchase_order_detail 
			WHERE
				( PUR_ORDER_ID, MATERIAL_ID ) IN ( SELECT PUR_ORDER_ID, MATERIAL_ID FROM b_purchase_order_detail GROUP BY PUR_ORDER_ID, MATERIAL_ID HAVING count( * ) > 1 );