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
- 8091 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
If I have a view which is a join of two or more tables, can this view be updateable?
Why do chiropractors use drop table?
What are the uses of db2 optimizer?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How many databases can be created inside an instance 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
Which components manage deadlocks in db2?
What is db2 catalog database?
What is the meaning concurrency in the db2 database?
How to rename a table in DB2 ?
What is rebind in db2?
What is the use of reorg in db2?
How to create db2 table in mainframe?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the difference between bind and rebind in db2?
