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

What are a database and a data warehouse?

972

What do you understand by the analysis services in sql server?

894

Explain the concepts and capabilities of sql server?

922

Can we delete data from a view?

882

How would you add a section to a table?

970

Explain how to integrate the ssrs reports in application?

945

What part does database design plays a role in performance of an sql server-based application?

928

Do you know what is bit data type and whats the information that can be stored inside a bit column?

911

How to skip remaining statements in a loop block using continue statements?

935

How do I port a number to sql server?

983

What is difference between clustered index and non clustered index?

1030

How to modify an existing user defined function?

1036

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1990

What are rest-style architecture's?

170

explain declarative management framework (dmf) in sql server 2008?

950