select * from (select rownum r , emp.* from emp) where r='&n�

How to select nth record from a table?

Question Posted / karthik

Answer Posted / karthik

select * from (select rownum r , emp.* from emp)
where
r='&n'

Give the value of n. It will return the nth record.

Is This Answer Correct ?

13 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is sql stored procedure?

1084

What is report rendering ?

155

What is inline table-value user-defined function?

1105

How to delete duplicate rows from table except one?

985

Define candidate key, alternate key, and composite key.

920

Explain error and transaction handling in sql server?

1007

Why use view instead of a table?

949

Tell me what are the advantages of using stored procedures?

1001

Do you know how to implement service broker?

928

What are the rendering extensions of ssrs?

157

Does sql server 2000 clustering support load balancing?

966

What is compression - row-level and page-level compression?

906

What is difference between index seek vs. Index scan?

1153

How will you find out if there are expensive SQL statements running or not?

1010

How can you append an identity column to a temporary table?

944