Select top 1 * from (Select top n * from tbl order by column name asc)tbl

How to select nth record from a table?

Question Posted / saravanan p

Answer Posted / saravanan p

Select top 1 * from
(Select top n * from tbl order by column name asc)tbl1
order by column name desc

Is This Answer Correct ?

19 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What is user defined stored procedures?

930

What is the purpose of linked server configuration in sql server?

1042

Why truncate is ddl?

1082

How to move database physical files in ms sql server?

1028

What is meant by Active-Passive and Active-Active clustering setup?

1170

how many clustered indexes can be created on a table? : Sql server database administration

1144

What is subreport?

141

How will you find out if there are expensive SQL statements running or not?

1010

How do you send email on SQL Server?

1057

How can we get count of the number of records in a table?

951

Define compound operators?

911

What is the default order of an order by clause?

988

what are the different types of SSRS reports?

152

Explain four layers of abstraction microsoft architectured?

147

Explain the properties of sub-query in sql server?

1007