a sub query is a query nested within another query while join select rows

Whatz the main diff between Subquery and a Join

Question Posted / gomolemo kasale

Answer Posted / gomolemo kasale

a sub query is a query nested within another query while
join select rows from multiple table

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the major difference between truncate and delete?

975

How to export data to a csv file?

1197

What is a system tablespace?

1000

Explain the use of parfile option in exp command.

985

What is rich query?

925

What is oracle latest version?

1037

What is oracle in java?

906

What is a tns file?

937

What is pragma autonomous transaction in oracle?

989

How to add another datafile to a tablespace?

989

How to rename an index?

992

What is oracle open database communication (odbc)?

957

How to best split csv strings in oracle 9i?

983

How to pass a cursor variable to a procedure?

1037

What is blob datatype?

1051