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

What are the different types of sub-queries?

997

What is dimension table? : sql server analysis services, ssas

976

What is update locks?

835

How to find the service pack installed? : sql server database administration

975

How to delete existing rows in a table?

1074

How do I create a stored procedure in sql server?

965

What does it mean to manipulate data?

944

What is data modeling and Reterminal integrity?

1905

Explain atomicity?

974

What is mapping schema?

987

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

978

What is it unwise to create wide clustered index keys?

956

what is the difference between delete table and truncate table commands? : Sql server database administration

968

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

936

Tell me what is fill factor?

907