If there is any specific order they have to be fetched then use fetch first

if there is a table with huge number of records and if i
want to extract only first 3 records from the table, what
query i have to provide to retreive first 3 records

Question Posted / viji

4 Answers
8106 Views
UST, I also Faced
E-Mail Answers

Answer Posted / viji

If there is any specific order they have to be fetched then use fetch first 3 records only.
Without order by, fetch first 3 records only will retrieve any 3 records in random order.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create db2 table in mainframe?

1154

What is release/acquire in bind?

1103

What is host variable?

1056

Which isolation level provides highest data integrity?

1117

What action db2 takes when a program aborts in the middle of a transaction?

1155

What is the difference between nvl and coalesce?

1065

What is meant by dclgen?

1109

How does db2 sample database connect?

1029

How to retrieve rows from a db2 table in embedded sql?

1390

What do you mean by rollback?

991

What is load replace in db2?

992

What db2 400?

1189

What is coalesce in db2?

1134

What is iseries database?

1046

What is the cobol picture clause of the db2 data types date, time, timestamp?

1067