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
What are group functions in oracle?
How to use regular expression in pattern match conditions in oracle?
Design database draw er diagram for a certain scenario ?
What is object data modeling?
How to retrieve data from an cursor to a record?
How to compare dates in oracle sql?
What is system tablespace?
what is the difference between functional dependecy and multilevel dependency?
How do I find the database name in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
How to create an oracle database manually?
Explain constraining triggers.
List the types of joins used in writing subqueries?
How to select all columns of all rows from a table in oracle?
Explain database link?