分组取前N条记录

以scott用户下的emp表数据为对象，查询（每个部门的员工编号前2位）：

1.

select a.empno,a.deptno
from employee a left join employee b on a.deptno=b.deptno and a.empno<b.empno
group by a.deptno,a.empno
having count(b.empno)<2
order by a.deptno,a.empno Desc;

2.

select * from employee a where 2 > (select count(*) from employee where deptno=a.deptno and empno>a.empno) order by a.deptno,a.empno Desc;