Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32897 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / affan
the main diff is
the subquery gives the result from one table only,but whose condition may depend on another table i.e the inner query.
whereas join gives the result from both the tables if condition is satisfied
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to establish administrator authentication to the server?
Can the query output be sorted by multiple columns in oracle?
Can we store pictures in the database and if so, how it can be done?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to list all tables in your schema?
What is a snapshot in oracle database?
How to convert numbers to characters in oracle?
What are the uses of a database trigger?
What is ordinary table in oracle?
Explain a data segment?
Explain self joins in oracle?
What is an oracle function?
What is the oracle implicit cursor?
Is there any function in oracle similar like group_concat of mysql?
Why does Oracle not permit the use of PCTUSED with indexes?
