select top 1 * from (select top n * from tbl order by col1 desc) tbl orde

How to select nth record from a table?

Question Posted / roxy

Answer Posted / roxy

select top 1 * from (select top n * from tbl order by col1
desc) tbl order by col1 asc

where n = nth number in the list

Is This Answer Correct ?

5 Yes

5 No

Please Help Members By Posting Answers For Below Questions

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1693

What is hot add cpu in sql server 2008?

938

What extended events?

1014

Which table keeps information about stored procedures?

954

What are the disadvantages of indexes?

1098

What is global temp table?

1007

How to test values returned by a subquery with the in operator?

1210

What is normalization? What number of normalization shapes are there?

1121

What happens if the update subquery returns multiple rows in ms sql server?

1133

What are the benefits of normalization?

1120

What is the difference between a stored procedure and a user defined function?

1033

What is difference between clustered index and non clustered index?

1083

What is BCP? When does it used in sql server 2012?

1073

What is the difference between an index and a unique index?

1010

Can group by and orderby be used together?

1029