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
What is dbrm? What it contains?
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.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is rebind in db2?
What happens in bind step in a db2 program?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
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
How to find the number of rows in db2 tables?
How does coalesce work?
What is db2? Explain.
What is cascading rollback?
What are the prerogatives?
What is multi row fetch in db2?
What is explain in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?