Select largest date?

From: Craig Alexander <craig_at_itas.net>
Date: Wed, 23 Feb 2000 18:07:28 GMT
Message-ID: <AlVs4.67$hr5.10771@sapphire.mtt.net>

Here is my SQL

SELECT ACCT.REVISION, ACCT.CREATED, ACCT_C.ACCT_NO, ACCT_C.FIRST_NAME, ACCT_C.LAST_NAME, ACCT_C.STATUS, SYS_VDESC.TEXT FROM ACCT, ACCT_C, ACTION, V_CANCEL_REASON, SYS_VDESC WHERE ACCT.ACCT_NO = ACCT_C.ACCT_NO AND ACCT_C.ACCT_NO = ACTION.REF_OBJ_ID AND
ACTION.REASON = V_CANCEL_REASON.REASON_NO AND V_CANCEL_REASON.DESCRIPTION = SYS_VDESC.DESCRIPTION AND

ACCT.CREATED >= '01-jan-99' AND
ACCT.CREATED <= '01-jan-00' AND
ACCT_C.STATUS = 0

ORDER BY ACCT_C.ACCT_NO ASC,
ACCT.CREATED ASC And Here is an example of what it returns

1. 6000264 Glen Macgonnell 0 1/28/00 5:49:00 AM Unknown
2. 6000264 Glen Macgonnell 0 1/25/00 11:24:31 AM Unknown
3. 6000278 Shelley Reactor 0 1/20/00 12:22:06 PM Unknown
4. 6000278 Shelley Reactor 0 1/20/00 12:23:31 PM Unknown

How do I get this query to return only the records with the latest dates (eg lines 2 and 4)?

Thanks
Craig

--

---

Craig Alexander Received on Wed Feb 23 2000 - 12:07:28 CST