Selecting a record by row number in MS SQL
Posted on 2002-06-07
How can I achieve the following in MS SQL ?
a) Selecting a record from the Nth position(row) of a table.
b) selecting a record which is between nth and mth position in a SQL server table.
Assuming table is ordered with a key, which can be varchar. We won;t be knowing the key value, but only the position.
In Oracle we can use rownum. what are options in MS SQL ?
Thanks in advance