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

Write a code to select distinct records without using the DISTINCT keyword.

1111

What is master database? : SQL Server Architecture

1017

What are the 10 characteristics of data quality?

950

In which files does sql server actually store data?

897

What programming language would you use to create embedded functions in ssrs?

184

How to delete duplicate records based on single column from a table?

1047

Explain the properties of the relational tables?

988

How can you find out how many rows returned in a cursor?

1025

Define views.

1004

What is the difference between implicit and explicit transaction?

1006

How do you check sql server is up and running?

992

What is a constant or literal in ms sql server?

1040

How to insert multiple rows with a subquery?

1127

Explain about merge replications?

1011

What are the events recorded in a transaction log?

992