select ename from emp order by ename offset 4 rows fetch next 5

display records from 5 to 9 using rowid or rownum

Question Posted / ramaraju

Answer Posted / ramaraju

select
ename
from
emp
order by ename
offset 4 rows
fetch next 5 rows only;

try this answer oracle 12c introduced offset fetch rows.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are sql constraints?

1127

what is bcp? When is it used?

1049

What is recursive join in sql?

948

Can we insert data into materialized view?

897

What is null in pl/sql?

1023

what are the different type of normalization? : Sql dba

974

Can we create table in function?

907

What is normalisation in sql?

1005

Does pl/sql support create command?

1045

What is the best free sql database?

1001

What is database white box testing and black box testing?

1049

Why is the cursor important?

979

Is sql free?

889

How do you clear the screen in sql?

1012

Is sql considered coding?

996