Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33918 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / anbu
their should be a relationship between the tables then only
we can use join conditions....
But the subquery can be used to retrive data from one or
more table if their is no relation between the tables....
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
What is Segment Advisor in Oracle?
What is the quickest way to fetch the data from a table?
What is an oracle function?
Can you assign multiple query result rows to a variable?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What do you understand by database schema and what does it hold?
what is the difference between substr and instr function in oracle?
Describe varray?
what is the scripts in data base?
How to store pictures on to the database?
What is the relation of a user account and a schema?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
Can we store pictures in the database and if so, how it can be done?
How to export your own schema?
