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
- 7944 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 commit in db2?
Where do you specify them?
How do you eliminate duplicate values in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the maximum No of rows per page?
What is a db2 table?
How do you select a row using indexes in db2?
What is the difference between cursor and select statement?
What is runstats db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is buffer pool and list some of them?
What is table space in db2?
What do you mean by cursor?
Is it possible using max on a char column?
Define predicate?
