I'm trying to write query in MSSQL which will return a single value, but the problem is, I want to get the result by a position in results, e.g.
SELECT [ID] FROM dbo.Users WHERE Status = 1
-- and then some code to get let's say fifth record from the result.
So far, what I've met is the TOP command that allows you to get top range of results.
So is it possible to retrieve a value by its position?