Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Manila, Philippines
    Posts
    20

    Unanswered: SELECT Nth record

    Hello!

    How can I make a SELECT query such that I am going to specify its position of the database....

    Like querying the 10th record of a table.

    Thanks

  2. #2
    Join Date
    Dec 2003
    Posts
    2

    Re: SELECT Nth record

    If you are asking about querying Nth record of a table ordered by a particular column, this could help:

    SELECT TOP 1 t1.*
    FROM (SELECT TOP 10 table1.*
        FROM table1
        ORDER BY col1) as t1
    ORDER BY col1 DESC


    Originally posted by bvmantos
    Hello!

    How can I make a SELECT query such that I am going to specify its position of the database....

    Like querying the 10th record of a table.

    Thanks

Posting Permissions

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