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 does sqlcabc has?

1099

Mention the downsides of page level lock.

1217

Which isolation level provides highest data integrity?

1189

Define db2 and its databases?

1113

How do I start db2 in windows?

1141

How to find schema of a table in db2?

1067

What is syscat in db2?

1072

How does coalesce work?

1071

What is null indicator in cobol db2?

1111

What is runstats and reorg in db2?

1362

What are the various isolation levels possible?

1181

What is a db2 cursor?

1109

What is iseries database?

1119

How does cobol compile db2 program?

1130

What types of tables are there in the db2 database?

1101