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
- 4 Answers
- 7244 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
How do I delete a column in db2?
What is the syntax for FETCH in DB2 ?
Define predicate?
What does db2 stand for?
Why do we bind in db2?
What is load utility in db2?
What is a db2 package?
What does db2 blu stand for?
What is the reason behind not using select * in embedded sql programs?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What parameters are used to control the free space in DB2?
Define data page.
What is the maximum size of varchar data type in db2?
What is blu acceleration in db2?
What is buffer pool?
