Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32890 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / a.n.v.v.siva kumar
The main difference between join and sub query is :
join is used to retrieve data from two different tables
where as in sub query we can retreive data from one table
using the result of the where condition on another table.
| Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
Why does oracle 9i treat an empty string as null?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is the difference between count (*), count (expression), count (distinct expression)?
What is open database communication (odbc) in oracle?
How to rename a column in an existing table?
What are internal user account in oracle?
How to assign query results to variables?
What is query image?
How can we view last record added to a table?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How view is different from a table?
What operating systems are supported by oracle database 10g xe?
What to do if dba lost the system password?
What is meant by an index?
What is an oracle table?
