select * from emp where rownum<=100 and rownum>=200;

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 / vikatakavi08

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

Answer Posted / vikatakavi08

select * from emp where rownum<=100 and rownum>=200;

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are concurrency issues?

1097

What is copy pending status in db2?

1127

Define predicate?

1132

What is the difference between spufi and qmf?

1132

What is the role of schema in the db2 database?

1275

Before you give the explain statement, what are the prerogatives?

1040

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1272

What is lock escalation in db2?

1033

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2045

How to fetch the last row from the table in SQL (db2)?

1655

What are the various isolation levels possible?

1122

How do I import data from excel to db2?

1074

What is the physical storage length of the data types date, time, and timestamp?

1090

What is the difference between plan and package in db2?

1113

What is the difference between oracle and db2?

1109