select * from (select rownum r ,a.* from emp a ) where r between 5 and 9

display records from 5 to 9 using rowid or rownum

Question Posted / chiru

Answer Posted / chiru

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does truncate need commit?

940

what are sequences

1741

Is sql easier than java?

1004

what is 'mysqlimport'? : Sql dba

1044

What is the difference between python and sql?

995

How do I run a query in pl sql developer?

991

What is sqlite used for?

989

Can we create view in stored procedure?

955

Can we use loop in sql?

967

What do you mean by “trigger” in sql?

1070

What does cursor do in sql?

1014

What is data type in sql?

952

what is the difference between clustered and non clustered index in sql? : Sql dba

1121

Can we edit a view in sql?

983

What is normalization in a database?

1152