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: [EMAIL PROTECTED]
www.enterasys.com
