I'm using Oracle. I have an inventory table with each record being a different inventory record, and each record includes the location within my warehouse. I need to get a count of locations that have 5 or more inventory records pointing to it.
Any pointers greatly appreciated!
Thanks,
jdkselect count(*)
from
where
group by xxx having count(*) > 5|||Originally posted by N-ary
select count(*)
from
where
group by xxx having count(*) > 5
Thanks!! I'm still validating results, but this appears to have been just what I needed.
jdk
Showing posts with label inventory. Show all posts
Showing posts with label inventory. Show all posts
Subscribe to:
Posts (Atom)