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 is sql in java?

547

what is 'mysqld'? : Sql dba

546

Explain commit, rollback and savepoint.

607

What is the execution plan in sql?

562

what is meant by urlencode and urldocode? : Sql dba

603

What is data type in sql?

556

What is the purpose of using pl/sql?

666

what are the different functions in sorting an array? : Sql dba

583

What are sql data types?

550

Explain some predefined exceptions.

589

What is coalesce in sql?

566

Is natural join same as inner join?

507

What is mdb stand for?

558

How do you update a sql procedure?

527

What are the main features of cursor?

631