I am the chief software engineer at Epicenter Consulting, a boutique software
company in New York City that specializes in developing high-end, customized business
solutions using ColdFusion and jQuery.
( more )
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 »