Re: Select record based on largest date? (updated question)

From: Craig Alexander <craig_at_itas.net>
Date: Wed, 23 Feb 2000 19:40:37 GMT
Message-ID: <VIWs4.81$hr5.12920@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 and time(eg
 lines 1 and 4)?

 Thanks
 Craig

 --

---

 Craig Alexander Received on Wed Feb 23 2000 - 13:40:37 CST