Whatz the main diff between Subquery and a Join
Answer Posted / adil khan
main difference between join and subqurey is that join is
used for known condition while subquery is used for unknown
condition.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How to define a record variable to store a table row?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are set operators?
What happens if you set the sga too low in oracle?
What is the fastest query method to fetch data from the table?
How to run create database statement again?
Explain overloading. Can functions be overloaded?
Explain the use of rows option in exp command.
How does Oracle guarantee data integrity of data changes?
What is SQL access advisor in Oracle?
What are data pump export and import modes?
20. Using a set operator, display the client number of all clients who have never placed an order.
How to create a table index?
What are the varoius components of physical database structure of oracle database?
How to assign query results to variables?