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 the usage of sql functions?

1144

What are three advantages to using sql?

1011

Explain sql data types?

1091

What are the different ddl commands in sql?

1164

how to run 'mysql' commands from a batch file? : Sql dba

1110

Which is better join or subquery?

1134

how can you see all indexes defined for a table? : Sql dba

992

What is a join?

1059

What is on delete restrict?

1000

what is union, minus and interact commands? : Sql dba

1185

How do you write an inner join query?

948

What is partition by in sql?

1064

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1187

What is the difference between execution of triggers and stored procedures?

1113

What is the difference between rollback and rollback to statements?

1060