Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    3

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

  2. #2
    Join Date
    Oct 2003
    Posts
    87
    select count(*)
    from
    where
    group by xxx having count(*) > 5
    Oracle - DB2 - MS Access -

  3. #3
    Join Date
    Nov 2003
    Posts
    3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •