Sunday, March 25, 2012

A Count of Counts?

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

No comments:

Post a Comment