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 is use of except clause? How does it differ from not in clause?

1020

what are different types of backups available in sql server? : Sql server database administration

932

Explain following error properties?

1014

What are the different types of stored procedures?

1117

Can binary strings be converted into numeric or float data types?

1033

Can we delete data from a view?

924

What is the difference between clustered and non-clustered indexes in ms sql server?

999

what are user defined datatypes and when you should go for them? : Sql server database administration

1017

Explain DBCC?

958

Can two tables share the same primary key?

910

What are the requirements to use odbc connections in php scripts?

1118

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1077

When would you use sql joins?

959

What is the difference between DATETIME2 and DATETIME?

1074

What is dbcc command in sql server?

1091