2 Replies Latest reply: Oct 4, 2013 2:12 PM by Pandiarajan Radhakrishnan RSS

    limiter the rows

    Pandiarajan Radhakrishnan

      Dear Friends,

       

          Table I   

      RegionRegionMail IDBranchBranchMailiDSubbranchSUBBRANCHMAILID
      M1M1@gmail.comB1B1@gmail.comS1B1S1B1@gmail.com
      M1M1@gmail.comB1B1@gmail.comS2B1S2B1@gmail.com
      M1M1@gmail.comB1B1@gmail.comS3B1S3B1@gmail.com
      M1M1@gmail.comB2b2@gmail.comS1B2S1B2@gmail.com
      M1M1@gmail.comB2b2@gmail.comS2B2S2B2@gmail.com

       

      Table II

       

      RegionReginTotalID
      M1M1@gmail.com;B1@gmail.com;B2@GMAIL.COM;S1B1@gmail.com;S2B1@gmail.com;S3B1@gmail.com;S1B2@gmail.com;S2B2@gmail.com

       

      i have data like Table I based on that i need Table II .  i want to avoid the left join. anybody suggest any functions or other methods