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 cobol picture clause of the db2 data types date, time, timestamp?

617

What are the contents of a dclmgen?

628

Define predicate?

643

What is release/acquire in bind?

656

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1709

How can deadlocks be resolved?

542

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

614

Why db2 is called db2?

593

Describe major components of db2?

640

How to run db2 command in windows?

651

How to access db2 tables in mainframe?

613

List down the types of triggers in the db2 database?

590

What is db2 bind process?

757

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

579

What is runstats and reorg in db2?

798