6 Replies Latest reply: Oct 15, 2012 12:22 PM by facundo de la cal RSS

    Minimum value.

      Hi All,

       

      i have a table in which a field Type which conatains two type of value X and y and in another column there is many numeric values but i want only latest and minimum values.

       

      table is like

       

      XandY, VALUE

      X,12754

      X,12721

      X,12719

      Y,4073

      Y,4072

      Y,3907

       

      I want the X minimum value X-12719 and Y-3907

      Please help

       

      Thanks