join is more efficeint, Subselect can be written as a join.

Compare a subselect to a join?

Question Posted / sunil1405

Answer Posted / sunil1405

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1046

What is netezza database?

1031

How do you find the maximum value in a column in db2?

1108

How can you count the number of rows from a table tab?

1093

Is db2 a database?

979

What is dbrm library?

1064

What is db2 purescale?

1007

What is query_cache_limit?

971

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11676

What is a db2 cursor?

1057

How to get the ddl of a table in db2?

1131

Where can you declare a cursor in a cobol-db2 program?

1077

What is innodb buffer pool?

1061

What is the maximum No of rows per page?

1070

What is the use of commit in db2?

1083