Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7887 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
What is load utility in db2?
What is alias in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How can you quickly find out the # of rows updated after an update statement?
What is db2 plan table?
What is the max length of sqlca?
What is dbrm? What it contains? When it will be created?
What is db2 and what is the use of db2 optimizer?
What is difference between rollback and commit?
What is meant by dclgen?
On which levels locks can be applied?
What are the uses of db2 optimizer?
What is the use of with ur in db2?
How to rename a table in DB2 ?
Is db2 free?
