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

select 100 records from million records ?

Question Posted / prachi

2 Answers
7991 Views
Verizon, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you mean by commit and rollback?

1049

Can you tell me how can you find out the # of rows updated after an update statement?

1101

How to run db2 command in windows?

1200

Outputs of explain are with matchcols = 0. What does this signify?

1062

What is the physical storage length of time data type?

1133

Why do we use cursor?

1106

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2334

List down the data types in the db2 database.

1132

How do you eliminate duplicate values in db2?

1201

What is collection in db2 bind?

1021

What is an instance in db2?

1040

Which components manage deadlocks in db2?

1074

What is scrollable cursor in db2?

1059

What is meant by union and union all?

1013

Mention the location where the output received from explain statement is stored.

1130