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

Does union all remove duplicates?

1123

What are the differences between lost updates and uncommitted dependencies?

1142

How to create a user name in a database?

1103

Can a database be shrunk to 0 bytes, if not, why?

1164

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

1029

Why we use functions in sql server?

1132

What is the meaning of sql server?

1037

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1127

What is dknf in normalization form?

1112

How to query multiple tables jointly?

1042

What is the simplest way to create a new database in ms sql server?

1051

How can I create a report based on a query? : sql server management studio

1064

What are the properties of primary key?

1015

Can an automatic recovery be initiated by a user?

1067

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

1012