Select Top 1 * From (Select Top N * from tablename order by table.Colum

How to select nth record from a table?

Question Posted / pravin s. ahire

Answer Posted / pravin s. ahire

Select Top 1 *
From (Select Top N * from tablename order by
table.ColumnName desc)

-- where N = nth record

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are distinctive joins find as a part of sql?

953

Can we add a cpu to sql server?

1018

What are the encryption mechanisms in sql server?

1033

What is the purpose of self join?

976

How to use “drop” keyword in sql server and give an example?

1133

What is a select query statement in ms sql server?

1084

What are indexes in ms sql server?

1064

What are the character string functions supported by sql server 2005?

1017

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

957

Is it true, that there is no difference between a rule and a check constraint?

1060

What is relationship? What number of sorts of relationship are there?

1143

What is the fastest way to permanently delete a 1 million row table named customers?

1255

What is a non-clustered index?

1000

What is coalesce in sql server?

1058

Can select statements be used on views in ms sql server?

1069