From: Hunter, Ray <rhunter@enterasys.com>
To: 'Postres-sql' (E-mail) <pgsql-sql@postgresql.org>
Subject: Getting a specific row from a table
Date: Wed, 13 Jun 2001 17:27:26 -0400
Message-ID: <59358A738F45D51186A30008C74CE2500A079E@slc-exc1.ctron.com> (raw)
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@enterasys.com
www.enterasys.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: rhunter@enterasys.com
Subject: Re: Getting a specific row from a table
In-Reply-To: <59358A738F45D51186A30008C74CE2500A079E@slc-exc1.ctron.com>
References: <59358A738F45D51186A30008C74CE2500A079E@slc-exc1.ctron.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox