Results 1 to 2 of 2

Thread: Last 12 records - SQL Server 7.0

  1. #1
    Join Date
    Nov 2004
    Posts
    7
    Rep Power
    0

    Default Last 12 records - SQL Server 7.0

    I would like a query to return the last 12 records of a table where the table is ordered in ascending order.

    I know that "Top 12" works to return the first 12 records but I want the last 12 in the same order.

    Thank You!!
    Last edited by a-dre; Dec 28, 2004 at 02:07 PM. Reason: Mispelled word

  2. #2
    Join Date
    Apr 2003
    Posts
    13,269
    Rep Power
    34

    Default Re: Last 12 records - SQL Server 7.0

    Why not sort the tables in descending order and get the top 12? You can always loop through the records in any direction to get them in the order you want.
    "The best software is the one that fits your needs." - A_A

    Virus free since: date unknown
    Anti-virus free since: August 2008

Posting Permissions

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