3 Replies Latest reply: Jan 23, 2014 4:41 AM by Henric Cronström RSS

    How to get the first or last instance

      Hi,

       

      May I ask how to get the first or second or last instance for the query below.

       

      I would like get the first and second instance of Transferre Date per Ticket. But as you can see in the attached image, most of the ticket number have duplicates because one ticket can transfer many times. My problem is how will I be able to get the first and second instance of transferred date.

       

      Thank you