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 dclgen (declaration generator)?

1060

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1047

What is an instance database?

1055

Which component is responsible for processing sql statements and selecting access paths?

1130

What is plan in cobol db2?

1140

What is an instance in db2?

1036

What is the clustering index in the db2 database?

1002

Explain dclgen.

1209

Mention the downsides of page level lock.

1163

what is db2 restart?

2162

What are the contents of a dclmgen?

1131

What is bufferpool in db2?

1055

How many types of page locks can be held in db2?

1044

How do you eliminate duplicate values in db2?

1195

What kind of database is db2?

1038