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
27047 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

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2906

Give the name of some fields form sqlca.

1058

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1027

What is the syntax for creating a table in the db2 database?

1093

What is drop table?

999

Define data page.

1048

What is schema in db2?

1008

What is runstats and reorg in db2?

1286

What is difference between alias and synonym in db2?

1119

On which levels locks can be applied?

1111

When reorg is used?

1111

What is the maximum number of columns in a db2 table?

1268

What is access path in db2?

969

Explain what are the various isolation levels possible?

1029

What is declare cursor?

1104