Usally subquery is executed first then result return to the main query.

What is subquery ?

Question Posted / v.chellappa

Answer Posted / v.chellappa

Usally subquery is executed first then result return to the
main query.
Based on the returned value the main querey is executed

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is consistency token in db2?

1060

What are db2 tables?

1046

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

1211

What is the use of commit in db2?

1000

Highlight all the advantages that are attached to a package.

1071

What is isolation level in db2?

939

What is db2 optimizer?

1177

How to check table size in db2 sap?

975

How to check last update on table in db2?

999

How to create db2 table in mainframe?

1100

What are the contents of a dclmgen?

1066

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1024

What is multi row fetch in db2?

983

What is difference between alias and synonym in db2?

1061

How do I change the column size in db2?

1081