Display latest record

Results 1 to 2 of 2

Thread: Display latest record

  1. #1
    KH Guest

    Default Display latest record

    How do you set up your SQL statement so that every day, the most recently entered record (ie. by date) in a database table is displayed on the page?<BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Display latest record

    Select top 1 from tablename<BR>order by columnname DESC;

Posting Permissions

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