Here N is for Nth record. SELECT TOP 1 * FROM (SELECT TOP N * FROM

How to select nth record from a table?

Question Posted / pallavi attarde

13 Answers
41307 Views
DELL, Microsoft, Ramco, I also Faced
E-Mail Answers

Here N is for Nth record.

SELECT TOP 1 * FROM
(SELECT TOP N * FROM
(SELECT Table.Coloumn1,Table.Coloumn2 from Table)
as d order by d.Coloumn1 desc) as p order by Coloumn1

Is This Answer Correct ?

8 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are acid properties of transaction?

995

Explain the collation?

1149

How to return the second 5 rows in ms sql server?

1108

What are the properties of primary key?

1015

How can sql injection be stopped? : sql server security

1104

Explain something about security and SQL Azure?

134

Indexes are updated automatically is the full-text index also updated automatically?

1065

How can you start sql server in different modes?

1019

How to use group functions in the select clause in ms sql server?

1119

Can you tell me some of the common replication dmv's and their use? : sql server replication

977

What are the properties of the relational tables?

928

Can we use max in where clause?

983

What is the use of stored procedure?

980

How do I partition a table in sql server?

1099

What are different types of join?

1377