Selecting Most Recent Row - Mailing list pgsql-sql

From Steve Meynell
Subject Selecting Most Recent Row
Date
Msg-id 3A37C7F2.A39482E4@candata.com
Whole thread Raw
Responses Re: Selecting Most Recent Row  ("Joel Burton" <jburton@scw.org>)
List pgsql-sql
Ok here is the problem. <br />Table: Widgets <br />Fields:  Unique_Key, DateStamp, Batch_Number, Instructions.
<p>BasicSelect Statement: <br />select Unique_Key from Widgets where Batch_Number>='inputedvalue' <p>Problem: <br
/>SomeBatch_Numbers might be duplicated over a period of time.  I want to select the most recent of these Batch
Numbers.<br />  <pre>-- 
 
Steve Meynell
Candata Systems</pre>  

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: How to represent a tree-structure in a relational database
Next
From: Mathijs Brands
Date:
Subject: Re: How to represent a tree-structure in a relational database