How many sub queries can you combine together ?

Question Posted / guest

4 Answers
10203 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 COPY PENDING status?

6 Answers

Explain transactions, commits and rollbacks in DB2.

3 Answers

What are iseries servers?

0 Answers

What is the maximum number of columns in a db2 table?

0 Answers IBM,

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers HeadStrong,

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers Cap Gemini,

What is the maximum No of rows per page?

0 Answers IBM,

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers IBM,

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers

What are db2 objects?

0 Answers

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers CTS,

For more DB2 Interview Questions Click Here