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 would you get the current date in mysql? : Sql dba

1017

What is a sql profiler?

1067

how to create a new table by selecting rows from another table in mysql? : Sql dba

1168

What is rank () in sql?

999

Can we insert data into view?

950

How is a process of pl/sql compiled?

1243

Can two tables have same primary key?

1024

What is the primary use of normalization?

1054

Can I call a procedure inside a function?

1076

What is the difference between subquery and correlated query?

1120

What is the difference between inner join and outer join?

1040

Is postgresql a server?

1114

what is a table in a database ? : Sql dba

1090

How to use distinct and count in sql query? Explain

1086

what is a composite primary key ? : Sql dba

1095