What about something like this:
select * from test order by tx_date desc limit 1
Yudie
- Original Message -
From: "Edmund Bacon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 5:09 PM
Subject: [SQL] Help refining/eliminating recur
On Thu, 19 Feb 2004, Edmund Bacon wrote:
>
> I have the following table:
>
> create table test (
> idserial primary key,
> product integer,
> tx_date date,
> quantity integer)
>
> with the following data:
> id | product | tx_date | quantity
> +-+---
I have the following table:
create table test (
idserial primary key,
product integer,
tx_date date,
quantity integer)
with the following data:
id | product | tx_date | quantity
+-++--
1 | 1 | 2004-01-01 | 10
2 |
