There is no
-
select nth record from table
-
You will have to think of a way to simulate it.
How you do that depends on a lot of things.
1) What version of SQL server do you have?
SQL server 2005 has a function that adds a row number field to a query.
ealier versions can do that through an auto number field in a temp table
2) Does any of your data naturally contain something you can use for
record sequencing.
For example a date field...like this to get the 10th record
-
SELECT Top 1 Date,Other,Fields
-
FROM
-
( SELECT Top 10 Date,Other,Fields
-
FROM TheTable
-
)a
-
ORDER BY Date DESC
-