MySql的复习(六):Union和Limit的用法MySql的复习(六):Union和Limit的用法
MySql的复习(六):Union和Limit的用法unionunion可以合并集合(相加)采用orselect ename,job from emp where job = 'MANAGER' or job = 'SALESMAN';查询job包含MANAGER和包含SALESMAN的员工select * from emp where job in('MANAGER', 'SALESMAN');采用union来合并select * from emp where job='