>For a given order of rows in a SQL Server table ( I.e. the natural order or the order an ORDER BY clause would generate ), is it possible to efficiently query the Nth row in the table?
>
>Thanks,
>Bill

Incomplete and Not extremely efficient:

SELECT TOP 1 * FROM
 (SELECT TOP N * FROM TABLE1 ORDER BY clause) X ORDER BY clause DESC