2 Replies Latest reply on Jan 28, 2015 11:36 PM by rp0428

    Retrun distinct rows with duplicate values

    932164

      Hi,

       

                 I have accnt id, addr1, addr2, city and state columns. I need to find out all the accnt ids which have same addresses and at the same time filter out the same accnt id's from the query.

      For eg:

       

      acctid     addr1     addr2     city     state

      1              101     101          wef     sd

      1                         101          wef     sd

      2               101     101          wef     sd

      3               101     101          wef     sd

      4              102     102          sdf     dc

       

      From the above data, I want to get filter out row 4 and get rows 1,2 and 3. How do I achieve this with a sql query

       

      Thank You,

      Arch