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

How do I kill a query in postgresql?

546

What is the plv (pl/vision) package offers?

605

Which sorts rows in sql?

579

What is mutating table error?

654

What is full join?

520

What is normalization? How many normalization forms are there?

548

How long does it take to learn pl sql?

601

What is exit statement?

537

Can we use views in stored procedure?

506

Is sql easier than java?

518

What are the different set operators available in sql?

561

how to return query output in html format? : Sql dba

644

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2086

Where do we use pl sql?

545

What is %rowtype in pl sql?

511