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 a temporal data type?

974

How do you write an index?

912

What is mutating error?

906

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1000

How do you sort in sql?

946

What is record data type?

857

Why we use cross join?

887

Define select, insert, create, delete, update, drop keywords

993

What is pl sql block in dbms?

944

What are the qualities of 2nf?

973

Can function return multiple values in sql?

982

What are the types of triggers in sql?

1013

what does the t-sql command ident_incr does? : Transact sql

1009

What is the example of procedure?

873

Does google use sql?

911