What is the purpose of coding FETCH in a SQL SELECT query?
Explain with an example in Detail?
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 are the 2 sqlcodes that are returned?
What are common abends
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What is a DB2 catalog?
What is Reorg Recovery? when will you run it?
What is lock escalation in db2?
How do you do the EXPLAIN of a dynamic SQL statement?
What do you need to do before you do EXPLAIN ?
What is index cardinality?
What is the use of db2?
What is precompiler in db2?
If I have a view which is a join of two or more tables, can this view be updateable?