SELECT * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY column

How to select nth record from a table?

Question Posted / soorai ganesh

Answer Posted / soorai ganesh

SELECT * FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY column_name) AS Rno,*
FROM Table_Name
)T
WHERE T.Rno = 7 -- If N is 7 other wise put ur nth value.

Is This Answer Correct ?

45 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Can we use max in where clause?

923

How will you add a dimension to cube? : sql server analysis services, ssas

1078

Do you know what are various aggregate functions that are available?

1114

Do you know how to implement service broker?

928

What are the components of dbms?

950

Explain triggers?

999

What is the filtered index?

1048

Explain the properties of the relational tables?

989

What is server-level principal?

122

What is an identity?

1008

Why use “in” clause in sql server?

1071

What is shrink log file?

895

User wants only to display only pdf as export option in report manager. How to achieve this?

262

what is the difference between openrowset and openquery?

1078

What is normalization 1nf 2nf 3nf?

1058