[jdkitch]

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,
jdk

[N-ary]

select count(*)
from
where
group by xxx having count(*) > 5

[jdkitch]

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