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
- 7265 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / gummadi
select * from table_name
order by ascending
fetch first 3 rows only
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is db2 command?
What is the difference between bind and rebind in db2?
What is buffer pool?
Is db2 free?
What is bind package and plan in db2?
How do you select a row using indexes in db2?
How do we specify index to include or not during bind process.
what are bind concepts in db2 cobol?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the clustering index in the db2 database?
What is image copy in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What do you mean by commit and rollback?
Which are the db2 tools to protect integrity of the database?
How will you return the number of records in table?
