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 to disable triggers using "disable trigger"?

1049

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1121

What are the 7 disadvantages to a manual system?

977

Explain different types of locks in sql server.

1071

What is the cartesian product of table?

1002

How do I partition a table in sql server?

1031

Write a SQL queries on Self Join and Inner Join.

1036

what type of index will get created after executing the above statement? : Sql server database administration

971

Can foreign key be duplicate?

1052

What is clustered index

996

How can we migrate from SQL server to SQL Azure?

113

can a database be shrunk with users active? : Sql server administration

1001

Explain full-text indexing?

971

What is set nocount on and what is set nocount off?

931

How do I run sql server 2014?

980