SELECT * FROM TABLENAME FETCH FIRST 100 ROWS ONLY; This will fetch 1st

select 100 records from million records ?

Question Posted / prachi

Answer Posted / prachi

SELECT * FROM TABLENAME
FETCH FIRST 100 ROWS ONLY;

This will fetch 1st 100 records

Is This Answer Correct ?

20 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the benefits you can get from mainframe connect?

524

Mention some fields that are a part of sqlca.

603

what is diffrence b/w file-aid tool and file-aid utility???

4183

What is syscat in db2?

582

Give a brief description of db2 isolation levels?

606

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

662

What is null indicator in db2?

606

How do I add a column in db2?

596

Give the name of some fields form sqlca.

614

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

2288

What is cobol db2?

572

What is a cursor in programming?

599

How does a cursor work?

560

Define sqlca.

651

What is a db2 tablespace?

602