union 默认会去除重复记录,若不想过滤,可加 union ALL

select * from t1 where a = xxx

union (distinct, 默认为distinct,会过滤掉重复记录,可指定all,则不会过滤重复记录)

select * from t1 where b = xxx

posted @ 2022-01-14 17:52  江湖凶险  阅读(473)  评论(0编辑  收藏  举报