Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Question Unanswered: Last 10 Recordes

    Is there any way to get the last 10 Recordes in a Table

    [Something like SELECT TOP 10]?


  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Hamm,

    Yep do the TOP 10 BUT order the records in descending order ...

    SELECT TOP 10 .... FROM .... WHERE .... ORDER BY ... DESC;

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Wink

    Originally posted by M Owen
    Hamm,

    Yep do the TOP 10 BUT order the records in descending order ...

    SELECT TOP 10 .... FROM .... WHERE .... ORDER BY ... DESC;
    Very easy, I haven't thought it .

    Thanks M Owen

Posting Permissions

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