select * from (select rownum as "记录数" ,emp.empno,emp.ename,emp.job from emp where rownum<=12) tb1 where 记录数>=4;