Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select (select count(*) from gt_roster where ROS_ROSTERPLAN_ID = RPL_ID)
- from gt_rosterplan
- where RPL_ID = 432065061
- SQL> select (select count(*) from emp2 where empdeptno = deptno)
- 2 from dept
- 3 where deptno=10
- 4 /
- (SELECTCOUNT(*)FROMEMP2WHEREEMPDEPTNO=DEPTNO)
- ---------------------------------------------
- 3
Add Comment
Please, Sign In to add comment