Difference between join and a subquery?
Answer Posted / maddy
Subquery is also query which returns one or more values we
can retriew the data based on the where contd="IN,ALL"...
subquery is the query followed by the main query....
join is used to join the two table is used to retriew the
data from 1 or more tables.....
| Is This Answer Correct ? | 27 Yes | 12 No |
Post New Answer View All Answers
11. Display the client number and name and the client number and name of the person who referred that client.
How many types of table in Oracle?
How different is ms access and oracle?
is there a tool to trace queries, like profiler for sql server?
How to change user password in oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What happens if the update subquery returns multiple rows?
What is the maximum number of triggers that can be applied to a single table?
What is parameterized cursor in oracle?
How to assign query results to variables?
How can we create the complete backup of data in the oracle.
Is the After report trigger fired if the report execution fails ?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Explain what are synonyms used for?
What are the general rules on data consistency?