Selecting 2 sets of data

[Sean Cook]

I have the following case and need some help ... I need to select two
groups of data based on the time stamp.

Table 1

Card | Date | Time | #1 | #2 | #3
-----------------------------------------------------
1 | 2004-09-09 | 19:39:21 | 841630 | 251534 | 110
2 | 2004-09-09 | 19:39:21 | 895424 | 256112 | 86
3 | 2004-09-09 | 19:39:21 | 895527 | 256881 | 109
1 | 2004-09-09 | 19:49:51 | 841750 | 251545 | 112
2 | 2004-09-09 | 19:49:51 | 895634 | 256173 | 88
3 | 2004-09-09 | 19:49:51 | 895937 | 256885 | 113
1 | 2004-09-09 | 19:59:42 | 841934 | 251554 | 112
2 | 2004-09-09 | 19:59:42 | 895886 | 256182 | 89
3 | 2004-09-09 | 19:59:42 | 896222 | 256892 | 113

I need the latest set of data (time 19:59:42) for all three cards and
then I will need the next previous set of data (time 19:49:51) for all
three cards.

After I have the data, I'll do calculations to arrive at %, etc.

To select the max time, I've tried the following:

select table1.* from table1 left join table1 as t2 on table1.card =
t2.card and table1.time < t2.time where t2.card IS NULL order by
date,time,card;

I don't know how to determine the previous set of data...

Any help would be greatly appreciated.