Ben Nadel at cf.Objective() 2011 (Minneapolis, MN) with:
( photo link )
Posted on Feb 20, 2011 at 12:34 PM
Finding TOP X records from each group SQL> select * from emp e 2 where e.empno in (select d.empno from emp d 3 where d.deptno=e.deptno and rownum<3) 4 order by deptno 5 ; EMPNO ENAME JOB MGR HIREDATE SAL COMM... read more »
Ben Nadel © 2014.
All content is the property of Ben Nadel and BenNadel.com