2 Replies Latest reply on Jan 31, 2013 7:10 AM by . Jasonz

    displaying only the oldest record

    . Jasonz

      Hi folks,

       

      Trying to get the following:

       

      I need to only retrive in a given row of data the newest line:

       

       

      ticket #         date         data

      001               jan 1         apple

      001               jan 2         apple

      001               jan 3         apple

      002               jan  1         purple

      002               jan  2         purple

      002               jan  5         purple

       

      should produce

      001               jan 3         apple

      002               jan  5         purple

       

      any ideas?

       

      jz