On Tue, Apr 12, 2005 at 12:24:21 -0500,
"A. R. Van Hook" <[EMAIL PROTECTED]> wrote:
> I have the following in a table:
> oid | citkey | contby | contdate | abcontinue | ccdate
> -++--+++
> 5774835 | 04-0594703 |
Try
"select oid,* from ccontinue where citkey ='04-0594703' group by
oid,citkey,contby,contdate,abcontinue,ccdate having contdate= max(contdate)"
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of A. R. Van Hook
Sent: Tuesday, April 12,
"A. R. Van Hook" <[EMAIL PROTECTED]> writes:
> I am trying to pull rows that have the max. contdate. Why does the
> following give more than 2 rows?
> ql "select oid,* from ccontinue where citkey ='04-0594703' group by
> oid,citkey,contby,contdate,abcontinue,ccdate having max(contdate) =
> cont
