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
- 7779 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
When reorg is used?
What is db2 bind?
Define data page.
How can you count the number of rows from a table tab?
What is the role of union all and union
what is db2 restart?
What is load utility in db2?
How to find the number of rows in a db2 table?
Is it possible using max on a char column?
Explain about cursor stability?
What is dclgen in db2?
What is access path in db2?
What is multi row fetch in db2?
What parameters are used to control the free space in DB2?
What are the full forms of spufi and dclgen and why are they used?
