maybe this is what you are looking for
SELECT warehouse,
COUNT(*) NUM_LINES,
(SELECT COUNT(1) OVER( PARTITION BY warehouse )
FROM inventory
WHERE warehouse='ACE'
AND q_RO > 0
AND b.q_oh=0) zero_bal
FROM inventory
WHERE warehouse='ACE'
AND q_RO > 0
|
Results 1 to 9 of 9
Thread: Nested Query in ORACLEThreaded View
|
Click Here to Expand Forum to Full Width |