Community Member Profile
bharath reddy
Member since Feb 20, 2011
- Profile: /members/7847-bharath-reddy.htm
- Comments: 1
- Points: 12
Recent Blog Comments By bharath reddy
-
Selecting Top X From Each Group
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 »
