MySQL union合并查询

​ union和union all

​ 区别:union将合并的结果去重;union all 不去重

​ select ename from emp where empno=7900 union select ename from emp where empno>=7900;

​ select ename from emp where empno=7900 union all select ename from emp where empno>=7900;900;

评论

暂无评论