Inorder to select first n number of rows fetch is used in conjunction wit

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

Question Posted / siri reddy

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

Please Help Members By Posting Answers For Below Questions

What is lock escalation in db2?

976

What is dpf in db2?

1062

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2876

What are the contents of a dclmgen?

1077

What is the clustering index in the db2 database?

962

What is package in db2 mainframe?

930

What is db2 connect?

1017

What are the 2 sqlcodes that are returned?

1140

What is a trigger in the db2 database?

1026

What is a db2 tablespace?

1009

What is database reorganization?

1068

What is iseries database?

1006

What is the use of predicate?

994

What is meant by explain?

1074

What is reorg and runstats in db2?

1160