How to select a row based on its row number?

A couple of the other answers touched on the problem, but this might explain. There really isn’t an order implied in SQL (set theory). So to refer to the “fifth row” requires you to introduce the concept

Select *
From 
(
    Select 
      Row_Number() Over (Order By SomeField) As RowNum
    , *
    From TheTable
) t2
Where RowNum = 5

In the subquery, a row number is “created” by defining the order you expect. Now the outer query is able to pull the fifth entry out of that ordered set.