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
- 8230 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 drop table?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What are foreign keys in db2?
What is the reason behind not using select * in embedded sql programs?
What are the various isolation levels possible?
What is page size in db2?
How can deadlocks be resolved?
What is a trigger in the db2 database?
what is the role of the cursor in db2?
Explain what are the various isolation levels possible?
How to get the ddl of a table in db2?
What is performance tuning db2?
How to find the maximum value in a column in the db2 database?
Mention the location where the output received from explain statement is stored.
What is dbrm in db2 database?
