Answer #7 should be select top 1 * from (select top n * from tbl order

How to select nth record from a table?

Question Posted / rathika

Answer Posted / rathika

Answer #7 should be

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

where n = nth number in the list

Is This Answer Correct ?

8 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is difference between oltp and olap?

980

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1033

Explain about unique identifier data type in sql server?

857

What is difference between foreign key and unique key?

962

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

112

What is oltp (online transaction processing)?

951

What is difference between createstatement and preparedstatement?

1022

How to list all user names in a database?

1004

what is the maximum size of a row? : Sql server database administration

940

What do you understand by a stored procedure?

1039

What is report subscription?

117

Define master database?

989

List some of the rules that apply to creating and using a ‘view’

814

What is the difference between getdate and sysdatetime?

941

What is transact-sql ddl trigger?

1047