7 Replies Latest reply: Aug 4, 2016 8:42 PM by Maiko Francisco Rugeria RSS

    Retrieving Data Through Identifiers

    Maiko Francisco Rugeria

      Hi!

       

      I have a table with that looks like this:

       

      ID    Item

      1     ItemA

      5     ItemF

      4     ItemS

      1     ItemJ

      1     ItemB

      4     ItemG

      5     ItemI

      ...

      1     ItemZ

      10   ItemD

       

      How can I output all IDs that have more than 1 item associated to them? For example:

       

      1

      4

      5

       

      Note: ID's with only one item are not included. Thank you!