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

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

935

What are “unrepeatable reads”?

1176

What is SubQuery in SQL Server 2008

962

What is a file group?

1015

What is sql profiler. What are the default templates with it? : sql server database administration

949

what is isolation level at dead lock?

2088

How do I find query history in sql server?

873

What does the on update no action do?

961

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

932

What are the differences between char and varchar in ms sql server?

998

How would you choose between a clustered and a non-clustered index?

914

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

919

What is the difference between cartesian product and cross join?

812

What are date and time data types in ms sql server?

1015

What are sql azure firewall rules?

106