Get second lowest value from database

[c8ltgkue]

Using CR XI

I work for a law firm and I would like to find out the second allocated solicitor for the case. for example.

CaseID Allocation date Solicitor ID
Case 1 01/11/2013 1111
case 1 13/11/2013 1112
case 1 24/11/2013 1113
case 1 30/11/2013 1114

so if I create a group on CaseID I would like to see 1112 in solicitor ID. Sorting by ascending or descending gives me 1111 or 1114 respectively. I would like to see the second allocated solicitor i.e ID 1112.

Help..!

 

[pmax9999]

Please don't post in multiple forums.