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 enable sql encryption?

1068

what is a field in a database ? : Sql dba

1096

Can you inner join the same table?

1036

What is materialized view in sql?

957

Does truncate free space?

1064

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1038

What are the 3 modes of parameter?

1203

what is innodb? : Sql dba

1163

What is a field in a database?

1099

Can we create a trigger on view?

944

How to install oracle sql developer?

1095

What is cost in sql execution plan?

1042

What is data type in database?

1039

What is minus?

1050

what is the different between now() and current_date()? : Sql dba

1069