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 use of pl/sql table?

1067

What is secondary key?

934

explain the delete statements in sql

1061

How to check if a column is nullable before setting to nullable?

1128

What are the sql aggregate functions?

1134

What is the difference between a procedure and a function?

1113

Which query operators in sql is used for pattern matching?

966

what are integrity rules?

1027

what is sql server agent? : Sql dba

1109

Explain commit, rollback and savepoint.

1002

What are the types of functions in sql?

1020

What is scope of pl sql developer in future?

1019

What is dba in sql? : SQL DBA

1044

how to escape special characters in sql statements? : Sql dba

1036

What's the procedure?

930