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

List out the data types available.

1204

What is difference between rollback and commit?

1204

What are the 2 sqlcodes that are returned?

1232

What is syscat in db2?

1070

Which component is used to execute the sql statements?

1145

How do I delete a table in db2?

1123

Is the primary key a clustered index?

1201

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2118

What is a Foreign Key?

1139

How will you return the number of records in table?

986

What are db2 tables?

1164

What is the use of db2 optimizer?

1172

What do you mean by storage group (stogroup)?

1079

Explain packages.

1168

What is cobol db2?

1044