16 Replies Latest reply: Feb 15, 2014 12:14 PM by Srikanth P RSS

    How to get min and max id

    Tan Soo Chin

      Hello Community,

       

      I want to get the min id and max id for the product. I have data like below:

       

                                                                               

      IDProduct
      3ProductA
      4ProductA
      5ProductA
      6ProductA
      7ProductA
      9ProductA
      10ProductA
      11ProductA
      12ProductA
      14ProductA
      15ProductA
      16ProductA
      20ProductB
      21ProductB
      23ProductB
      25ProductB
      26ProductB
      27ProductB

       

      This is what i want to get:

       

                                              

      MinMaxProduct
      37ProductA
      912ProductA
      1416ProductA
      2021ProductB
      2323ProductB
      2527ProductB

       

      Anyone got idea how to get this? Thanks in advance.