I have a table that holds unique "entries" related to help desk tickets. Each entry is given a sequence number (assigned ascending for each entry regardless of ticket association). So, a ticket ID can have multiple entry records with ascending numbers. I need to be able to list the ticket id and only the first entry, which would be the min value of all entries. For instance:
CALLID CALLSEQ DATE TIME
0011 91038 01/01/18 8:10am
0011 91041 01/01/18 9:30am
0012 91053 01/01/18 8:45am
0012 91059 01/02/18 3:45pm
I need to return the following:
CALLID CALLSEQ DATE TIME
0011 91038 01/01/18 8:10am
0012 91053 01/01/18 8:45am
Ultimately, I need to evaluate ticket open date/times against the first entry date/time and display the DateDiff. Thanks in advance!!