SELECT * FROM TABLE FETCH FIRST 100 ROWS ONLY

how to fetch first 100 rows in db2

Question Posted / sesha

Answer Posted / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

Is This Answer Correct ?

34 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the syntax for FETCH in DB2 ?

671

How do you find the maximum value in a column in db2?

648

Can there be more than one cursor open for any program?

657

What is db2 stogroup?

673

what is the sqlcode -501

11287

What is the maximum size of a char data type in db2?

584

What is table space in db2?

576

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

2274

can all users have the privilage to use the sql statement select * (dml)?

638

Define predicate?

643

How do I delete a table in db2?

643

What is a page in db2?

608

If I have a view which is a join of two or more tables, can this view be updateable?

688

What is lock escalation in db2?

572

How do you concatenate the firstname and lastname from emp table to give a complete name?

599