From: | "Hunter, Ray" <rhunter(at)enterasys(dot)com> |
---|---|
To: | "'Postres-sql' (E-mail)" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Getting a specific row from a table |
Date: | 2001-06-13 21:27:26 |
Message-ID: | 59358A738F45D51186A30008C74CE2500A079E@slc-exc1.ctron.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-06-13 21:38:45 | Re: large going giving errors. |
Previous Message | jeff | 2001-06-13 21:23:14 | RE: large going giving errors. |