How many sub queries can you combine together ?

Answer Posted / aditya

15 such nested level is possible.

Is This Answer Correct ?    14 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dbrm? What it contains?

893


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1482


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1840


What is rebind in db2?

761


What happens in bind step in a db2 program?

718


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

845


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

962


How to find the number of rows in db2 tables?

788


How does coalesce work?

748


What is db2? Explain.

773


What is cascading rollback?

843


What are the prerogatives?

797


What is multi row fetch in db2?

761


What is explain in db2?

761


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

2892