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

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

Question Posted / akviswa

Answer Posted / akviswa

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1135

What is db2 bind?

1016

What are catalog tables in db2?

980

What are union and union all?

920

What is cursor in dbms?

1005

Before you give the explain statement, what are the prerogatives?

969

How to connect to db2 database from windows command line?

1000

Name the lockable units in DB2?

1073

What are host variables in db2?

991

What are db2 tables?

1050

What is db2 bind process?

1179

Name the various locking levels available?

1035

What are bind parameters in db2?

981

What does reorg do in db2?

984

What is query_cache_limit?

928