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

Mention the uses of stored procedures.

1006

How would you add a section to a table?

1107

How to rename databases in ms sql server?

1255

Do you know clustered and non-clustered index?

1018

Explain log shipping and mention its advantages.

1085

Why I can not enter 0.001 second in date and time literals in ms sql server?

1104

How real and float literal values are rounded?

1196

Explain the etl (extraction, transformation, and loading)?

1048

Define indexes?

1094

Does sql server 2016 have ssms?

1004

What is difference between global temporary tables and local temporary tables?

1276

How to create user defined functions with parameters?

1292

What is side by side migration in sql server?

1170

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2111

What are the different authentication modes in sql server?

1164