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 ?

18 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What is SQL Azure Federations?

Define inner join in sql server joins?

537

How many replicas are maintained for each SQL Azure database?

128

Is foreign key unique?

581

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1854

Which is the latest version of sql server and when it is released?

550

What is the purpose of floor function?

544

What do you understand by replication in sql server?

582

what is database replication? : Sql server database administration

537

How to specify the collation for a character data type in ms sql server?

561

Explain “@@rowcount” and “@@error” in sql server?

541

What does man by sql wildcard characters in sql server?

529

What is user-defined inline table-valued function?

523

What are trace flags and mention a few common trace flags used with sql server?

557

How can windows applications connect to sql servers via odbc?

591