I've following data set and I required to get the result as answer.
Sample records of my Data set:
Custid. Activity date time Contact person
123456. 2001-07-07:07:432. Anthony
123456. 2003-09-09:09:567. Kamal
123456. 2009-08-09:06:654. Ruby
Result required in a single row:
Custid. First_actvity_date. Last_activity_date. First_contact_person.
123456. 2001-07-07:07:432. 2009-08-09:06:654. Anthony
Thanks in advance,