Getting a specific row from a table

My problem is that I want to pull to specific rows from a query result.

First here is the query:
SQL-query:
select card, status, time_stamp, comp_date
from test_record
where id = 45
order by card, comp_date

Next here is the result:

card status time stamp
Comp_Date
ER16-04 ER16-08 No 2001-06-13
13:56:52-06 6/10/01
ER16-04 ER16-08 Yes 2001-06-11
11:37:04-06 6/11/01
ER16-04 ER16-08 No 2001-06-11
13:13:07-06 6/11/01
ER16-04 ER16-08 No 2001-06-11
13:13:37-06 6/11/01
ER16-04 ER16-08 No 2001-06-13
13:57:41-06 6/12/01
ER16-04 ER16-08 Yes 2001-06-13
13:10:46-06 6/13/01
ER16-04 ER16-08 No 2001-06-13
13:35:29-06 6/13/01
SSR-ATM29-02 SSR-FDDI-02 No 2001-06-11 13:21:01-06
6/11/01
SSR-ATM29-02 SSR-FDDI-02 Yes 2001-06-11 13:21:17-06
6/11/01
SSR-ATM29-02 SSR-FDDI-02 No 2001-06-11 13:21:41-06
6/11/01
SSR-ATM29-02 SSR-FDDI-02 Yes 2001-06-11 13:22:21-06
6/11/01

What I want is the two rows that are bold. However this list will continue
to grow and have more card types. I always want the last card type in the
card group, because this has the comp_date that I am looking for.

Thanks,

RAY HUNTER
Automated Test Group

ENTERASYS NETWORKS

Internal: 53888
Phone: 801 887-9888
Fax: 801 972-5789
Cellular: 801 698-0622
E-mail: rhunter(at)enterasys(dot)com

www.enterasys.com