Duncan Hill [EMAIL PROTECTED] wrote:
I have a table that has data that looks like:
++-+---+-+
| id | recdate | mount | perused |
++-+---+-+
| 1 | 2004-05-20 10:46:12 | QUAR | 80 |
| 2 | 2004-05-20
Egor Egorov [EMAIL PROTECTED] wrote:
Duncan Hill [EMAIL PROTECTED] wrote:
I have a table that has data that looks like:
++-+---+-+
| id | recdate | mount | perused |
++-+---+-+
| 1 | 2004-05-20 10:46:12 |
On Thursday 20 May 2004 12:49, Egor Egorov might have typed:
Duncan Hill [EMAIL PROTECTED] wrote:
I have a table that has data that looks like:
++-+---+-+
| id | recdate | mount | perused |
++-+---+-+
Since your on 4.1, give this a try...
select *
from tbl as a
where a.recdate=(select max(b.recdate)
from tbl as b
where b.id=a.id and b.mount=a.mount)
Ed
-Original Message-
From: Duncan Hill [mailto:[EMAIL PROTECTED]
Subject: Re: Query help