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



What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?..

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

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?..

Answer / 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

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?..

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

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?..

Answer / akviswa

PS: fetch can be used in select only in case of cursor
select

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What are the 2 sqlcodes that are returned?

0 Answers  


What are common abends

1 Answers   SPIC, Virtusa,


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,


What is a DB2 catalog?

2 Answers  


What is Reorg Recovery? when will you run it?

2 Answers  


What is lock escalation in db2?

0 Answers  


How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  


What do you need to do before you do EXPLAIN ?

1 Answers  


What is index cardinality?

3 Answers  


What is the use of db2?

0 Answers  


What is precompiler in db2?

0 Answers  


If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  


Categories