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 network traffic be reduced by using the stored procedure?

1044

Can we use where clause in union?

1000

Write a sql query to sort on different column name according to the parameters passed in the function?

851

What is indexed view?

926

What is full outer join in sql server joins?

981

What are the differences between substr and charindex in sql server.

1012

List the different normalization forms?

925

Explain transaction server isolation?

979

Which sql server table is used to hold the stored procedure script?

881

What are tables in sql server?

961

How to automatically create a log when an exception is being received into SQL Server?

1207

What is create command?

924

How to retrieve field values using mssql_result()?

1183

How to scale out a federation by Sql statement?

116

Can you tell me about the concept of ER diagrams?

1017