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

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2857

What is precompiler in db2?

1025

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1080

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3157

How to create db2 table in mainframe?

1157

Differentiate between cs and rr isolation levels? Where do you specify them?

1072

How to take backup of table in db2?

1079

What os does db2 run on?

992

Which isolation level provides highest data integrity?

1126

Mention data types used in db2 ?

1166

What is role in db2?

1110

What is the role of schema in the db2 database?

1278

How to check table size in db2 sap?

1043

What is copy pending status in db2?

1127

What is consistency token in db2?

1147