select * from (select * from emp ) where rownum>=1 and rownum<5

I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!

Question Posted / vijay reddy

17 Answers
26455 Views
KNIT, Tech Mahindra, I also Faced
E-Mail Answers

Answer Posted / vijay reddy

select * from (select * from emp ) where rownum>=1 and rownum<5

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Name the various locking levels available?

1035

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11615

Define predicate?

1065

Which isolation level provides highest data integrity?

1039

What is runstats utility in db2?

962

How can you count the number of rows from a table tab?

1040

What is host variable?

1011

What is cloudant database?

1032

What is schema in db2?

962

How do we specify index to include or not during bind process.

2070

What is the maximum length of sqlca?

1432

Define data page.

1012

What is package in db2 mainframe?

917

Define buffer pool.

997

What is role in db2?

1040