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
- 7812 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
FETCH is used to retrieve a specific row from a result set
of the SELECT query and places them into local variables.
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
Answer / siri reddy
Inorder to select first n number of rows fetch is used in
conjunction with select statement
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / akviswa
PS: fetch can be used in select only in case of cursor
select
| Is This Answer Correct ? | 0 Yes | 0 No |
What is REORG? When is it used?
What is bind package and plan in db2?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is difference between rollback and commit?
What is referential integrity?
how we will do null data selection in cobol-db2 program
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
what is db2 restart?
What is the command used by TSO users to invoke DB2?
Could anyone clearly explain the diference between sub query and correlated sub query?
Which is faster delete or truncate?
How to connect to db2 database from windows command line?
COBOL 
