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

What is host variable in db2 cobol?

1032

What is the syntax for creating a table in the db2 database?

1060

What is runstats and reorg in db2?

1242

What is concurrency?

1153

What is the use of runstats in db2?

1024

What is syscat in db2?

952

When the like statement is used?

1157

Which component is responsible for db2 startup and shutdown?

985

What are db2 objects?

1003

What is the use of value function?

1076

Explain various types of locks in db2?

1086

What is table space in db2?

963

What is meant by explain?

1064

Which components manage deadlocks in db2?

1021

What are the contents of dclgen?

1054