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

Define a cross join?

1008

How to list all triggers in the database with sys.triggers in ms sql server?

1074

What are out-of-range errors with date and time literals?

1027

how you can list all the tables in a database?

1022

How do you delete a data source?

1003

What are temporal tables in sql server 2016?

881

How to drop an existing table with "drop table" statements in ms sql server?

1084

What is sql server query analyzer?

1025

Explain about unique identifier data type in sql server?

907

What are the operating modes in which database mirroring runs?

1082

How to create a Master database in SQL server ?

1083

How to make remote connection in database?

1002

What is standby servers? Explain types of standby servers.

993

Can we deploy SSRS reports on our personal website?

168

What happens to a trigger with multiple affected rows?

937