解决办法：加上order by null 不让它排序
select * from emp group by empno order by null;
select * from dept, emp where dept.deptno=emp.deptno; [简单处理方式] select * from dept left join emp on dept.deptno=emp.deptno; [左外连接，更ok!]
原文：http://www.cnblogs.com/ChaosJu/p/4545433.html