1 Reply Latest reply: Dec 14, 2012 1:22 PM by Celambarasan Adhimulam RSS

    First Sorted Value

    Jagan Vijayakumar

      I have a table like one shown below

       

      T1T3T2
      AA0
      AB1
      AA2
      BB2
      BA1
      BB0
      CA1
      CB2
      CA3
      DB1
      EA1
      EB0
      FA1
      FB1
      GA2


      I want to find first Row of T2 for each T1 as shown below. Please help.

       

      T1T3T2
      AA0
      BB2
      CA1
      DB1
      EA1
      EB0
      FA1
      GA2

       

      I tried using first sorted value but I was not able to write.

       

      could someone please help me.

       

      Thanks in advance.