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
26458 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 is cursor with hold option in db2?

1010

What is the reason behind not using select * in embedded sql programs?

1044

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1092

Can you use max on a char column?

1027

What os does db2 run on?

925

Is db2 a programming language?

983

Explain about cursor stability?

982

How is the value function used?

1080

How would the varchar column remarks defined?

1036

Which component is responsible for db2 startup and shutdown?

980

What are union and union all?

920

What are the bind parameters ibm db2?

989

How to check table size in db2 sap?

975

What is host variable in db2 cobol?

1028

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

1023