union all两个表后查询出重复数据

要查询出union all两个表后的重复数据，可以使用以下SQL语句：

SELECT * FROM (
SELECT column1, column2, ... FROM table1
UNION ALL
SELECT column1, column2, ... FROM table2
) AS combined_table
GROUP BY column1, column2, ...
HAVING COUNT(*) > 1;

其中，table1和table2是要进行union all操作的两个表，column1、column2等是要查询的列名。通过将两个表的数据合并后，使用GROUP BY和HAVING语句来筛选出重复的数据。
#### 引用[.reference_title]
- *1* *3* [多表连接【union all ，join】的查询问题](https://blog.csdn.net/ybw_2569/article/details/125850229)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [MySQL UNION 和 UNION all 操作符将两个结果集合并一个表](https://blog.csdn.net/helloxiaozhe/article/details/88598003)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]