select * from (select row_number() over(order by empid) rno,* from tbl)

How to select nth record from a table?

Question Posted / saravanan p

Answer Posted / saravanan p

select * from
(select row_number() over(order by empid) rno,* from tbl)
tbl1
where tbl1.rno=n

Is This Answer Correct ?

8 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is an execution plan? When would you use it?

921

What is filtered index?

1046

List the different normalization forms?

929

Do you know concepts and capabilities of sql server?

1007

What is primary key and example?

898

How to insert multiple rows with one insert statement in ms sql server?

1057

What is scheduled job and how to create it?

925

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

958

Which rendering formats are affected by the pagesize properties?

134

What is openrowset sql server?

1064

How to add code to the existing article (using improve article)?

1050

What are the types of normalization?

972

Mention the differences between substr and charindex in sql server.

985

Why use cursor in sql server?

1007

What is a primary key?

901