Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of coding FETCH in a SQL SELECT query?
Explain with an example in Detail?
- 4 Answers
- 8114 Views
- I also Faced
- E-Mail Answers
Answer Posted / anandrao
FETCH will give only the number of rows equal to the number
specified with FETCH from resultset given by query.
e.g. consider ACCOUNT_MASTER table contains 100 rows.
SELECT *
FROM ACCOUNT_MASTER
FETCH FIRST 10 ROWS ONLY.
Will give only first 10 rows of ACCOUNT_MASTER table from
100 rows of ACCOUNT_MASTER table
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is db2 plan table?
Which isolation level provides highest data integrity?
What is image copy in db2?
What is the maximum size of varchar data type in db2?
What is the difference between spufi and qmf?
What is db2 optimizer?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the role of data manager in the db2 database?
What is the advantage in De-normalizing tables in DB2?
What is drop table?
How would you find out the total number of rows in a db2 table?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is buffer pool in the db2 database?
Explain the function done by data manager?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
