Hi Bruce,
bruce wrote:
hi...
a further test...
the following test tbl/information:
dog
name char
statusint
_date timestamp
idint
here's the tricky part. if i want to get the row with the status=3, but only
if there's not a status=4 that has a later date, how
Hi,
This will do:
select name,status, max(_date) from dog
where status <(select max(status) from dog where status=dog.status) group
by name;
Thanks
ViSolve DB Team.
- Original Message -
From: "bruce" <[EMAIL PROTECTED]>
To:
Sent: Friday, January 05, 2007 10:23 AM
Subject: db/query
