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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment