Select latest record

Results 1 to 2 of 2

Thread: Select latest record

  1. #1
    Join Date
    Dec 1969

    Default Select latest record

    I&#039;m trying to Select the record with the most recent insert date. <BR>My table has the following columns:<BR><BR>ID<BR>AddDate &#039;uses getdate()<BR>Data1<BR>Data2<BR><BR>I want to find the record with the latest &#039;AddDate&#039; where ID = 3<BR><BR>Any help?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Select latest record

    Try to OrderBy AddDate and use only the first record in the recordset.<BR><BR>Any other ideas?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts