How many sub queries can you combine together ?

Question Posted / guest

4 Answers
10419 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How many sub queries can you combine together ?..

Answer / aditya

15 such nested level is possible.

Is This Answer Correct ?

15 Yes

5 No

How many sub queries can you combine together ?..

Answer / deepak

Is This Answer Correct ?

2 Yes

1 No

How many sub queries can you combine together ?..

Answer / sujeesh

Is This Answer Correct ?

4 Yes

4 No

How many sub queries can you combine together ?..

Answer / saikat

255

Is This Answer Correct ?

2 Yes

2 No

Post New Answer

More DB2 Interview Questions

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers IBM,

Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers

What are the different types of base tables?

0 Answers

What can the Locate option of the Repair Utility accomplish?

2 Answers

What is coalesce in db2?

0 Answers

Why do we use cursor?

0 Answers

What is a subselect? Is it different from a nested select?

1 Answers

What are the contents of a dclmgen?

0 Answers

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers IBM,

Mention data types used in db2 ?

0 Answers

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers

what is datacom db?

2 Answers CSC,

For more DB2 Interview Questions Click Here