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

    Retrun distinct rows with duplicate values




                 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,