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
- 7975 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
How can we read records for specific member in CL? AND rpg?
What is the max length of sqlca?
List out the data types available.
Define buffer pool.
Define sqlca.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Explain packages.
Name the lockable units in DB2?
What is a db2 table?
what is utility for parm lib
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
what is a corelated subquerry?
What is the difference between spufi and qmf?
Mention the downsides of page level lock.
