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