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

How is foreign key related to primary key?

972

How to create new tables with "create table" statements in ms sql server?

1066

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

how to determine the service pack currently installed on sql server? : Sql server database administration

976

What is tablix?

163

What is key attribute?

939

Explain concepts of analysis services?

964

Can a table have 2 primary keys?

987

How to store and query spatial data?

997

What is cursors?

1191

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

891

How can we improve performance by using SQL Server profiler?

1058

Is BCNF better than 2NF & 3NF? Why?

1050

What is the recovery model?

992

What is difference statement and preparedstatement?

986