sub query: it is a query to get the answer for multiple questions joi

Difference between join and a subquery?

Question Posted / rajasekhar

Answer Posted / rajasekhar

sub query: it is a query to get the answer for multiple questions

joins: it is used for getting the data from more then two tables

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to write numeric literals in oracle?

1124

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1876

How much memory your 10g xe server is using?

1050

Explain the different normalization forms?

1009

How do I spool to a csv formatted file using sqlplus?

964

What is execute immediate in oracle?

949

How to insert multiple rows with one insert statement in oracle?

1020

Explain about achiever in sql?

979

How can we find out the duplicate values in an oracle table?

993

Please explain oracle data types with examples?

990

How does one get the view definition of fixed views/tables?

967

How to retrieve the count of updated rows?

1054

What is oracle thin client?

973

What is varray?

1034

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2300