select rn, ename from (select rownum rn, ename from emp) where rn betwee

A table has 150 records. How do you retrieve 100th row to
120th row from that table ?

Question Posted / ajit nayak

Answer Posted / ajit nayak

select rn, ename
from (select rownum rn, ename
from emp)
where rn between 3 and 7;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to use distinct and count in sql query? Explain

1030

Can we join two tables without common column?

1012

What are sql queries used for?

1031

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

977

What is sqlcontext?

1089

how to fetch common records from two tables? : Sql dba

1182

What is microsoft t sql?

951

How do you delete data from a table?

1047

Can variables be used in sql statements?

1037

when MSQL8.0 is in market

2082

What is the difference between a primary key and a clustered index?

993

Can you inner join the same table?

996

Explain what is a view?

1066

What is meant by truncate in sql?

1070

What is AUTH_ID and AUTH_USER in pl/sql ?

2196