Last 3 records

Results 1 to 3 of 3

Thread: Last 3 records

  1. #1
    Adrian Guest

    Default Last 3 records

    Is it possible to just select the last three records?<BR>if would i go about doing this, would i find EOF and - 3 to go back 3 records.<BR>really have no idea, can someone place me on the correct path to solveing it.<BR><BR>-Adrian

  2. #2
    Join Date
    Dec 1969

    Default ORDER BY DESC

    Last 3 records *in what order*???<BR><BR>By user name? By recordID? By date?<BR><BR>Anyway:<BR><BR>SELECT TOP 3 * FROM table ORDER BY someField DESC<BR><BR>That will get you the last three records in reverse order.<BR><BR>

  3. #3
    Adrian Guest

    Default Thank you :-)


Posting Permissions

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