How many sub queries can you combine together ?

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 ?    14 Yes 5 No

How many sub queries can you combine together ?..

Answer / deepak

15

Is This Answer Correct ?    2 Yes 1 No

How many sub queries can you combine together ?..

Answer / sujeesh

32

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 universal database?

0 Answers  


How does coalesce work?

0 Answers  


which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  


What does the CHECK Utility do ?

1 Answers  


db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  






why we go for SPUFI for creating tables or for sql queries?

4 Answers  


How would you print the output of an SQL statement from SPUFI?

2 Answers  


Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,


What is the difference between using bind () and rebind () methods of naming class?

0 Answers  


a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


What are concurrency issues?

0 Answers  


Categories