Select Statement how to select a particular row

First of all, read my comment to the question and comment to the solution no. 1.

Secondly, read it: http://stackoverflow.com/questions/10387386/equivalent-of-limit-in-t-sql[^]

WITH Members  AS
(
    SELECT  M_NAME, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_COUNTRY,
            ROW_NUMBER() OVER (ORDER BY M_POSTS DESC) AS RowNumber
    FROM    dbo.FORUM_MEMBERS
)
SELECT  RowNumber, M_NAME, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_COUNTRY
FROM    Members
WHERE   RowNumber BETWEEN 1 AND 20
ORDER BY RowNumber ASC;

and this: http://msdn.microsoft.com/en-us/library/ms175972.aspx[^]

I think, depend on your conditions, you can use something like this to return praticular row:

SELECT *
FROM Yourtable
WHERE FieldID = @ID

More at: http://msdn.microsoft.com/en-us/library/ms188047.aspx[^]

You can use TOP clause to:

SELECT TOP(1) *
FROM (SELECT TOP(5) * FROM YourTable ORDER BY FieldID DESC) AS DT

More at: http://msdn.microsoft.com/en-us/library/ms189463.aspx[^]

select MAX(model) from Product where model in( select top 5 model from Product order by model );

If you are using Oracle there are 2 ways in my opinion to do it.

Use nested subquery to get the n-th row:

select * from (
select A, B, rownum Ind from Table_1
where rownum <= 5
order by A, B
)
where Ind = 5

Or group it by acquiring columns and use "having" clause which also works:

select A, B, rownum, count(*) from Table_2
group by A, B, rownum
having rownum = 5
order by A, B