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

Difference between connected and disconnected database in .net with sql server?

1150

What will be the maximum number of indexes per table?

1021

What is efficiency data?

1004

How do you manipulate data?

949

what are the new features in SSRS?

147

why would you call update statistics? : Sql server database administration

1162

What is use of @@ spid in sql server?

1277

What is partition, how will you implement it? : sql server analysis services, ssas

1103

Tell me what is difference between clustered and non clustered index?

984

What is lock escalation? : sql server database administration

1200

Does partitioning improve performance sql server?

1036

Where sql server usernames and passwords are stored in a sql server?

1040

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1027

Explain “row_number()” in sql server with an example?

1057

How to remove duplicate rows from table except one?

1064