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 string functions in sql?

1231

what is the difference between char and varchar data types? : Sql dba

1085

What are functions in sql?

950

How many joins can you have in sql?

930

Are views faster than queries?

984

How to get each name only once from an employee table?

1109

define join and explain different type of joins? : Sql dba

946

Does sql*plus also have a pl/sql engine?

1074

How do I create a memory optimized filegroup?

958

Can we use update in sql function?

1055

How many developers work on postgresql?

971

What is pivot table in sql?

1096

Why having clause is used in sql?

973

What is a trigger word?

1016

What is the maximum number of rows in sql table?

1021