pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (2+ messages)  latest in thread

Message-ID: <59358A738F45D51186A30008C74CE2500A079E@slc-exc1.ctron.com>
Permalink:  ../59358A738F45D51186A30008C74CE2500A079E@slc-exc1.ctron.com/
Also on:    postgresql.org/message-id/59358A738F45D51186A30008C74CE2500A079E@slc-exc1.ctron.com

 · 

reply

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