Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33897 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
What is the use of aggregate functions in oracle?
What are the logical operations?
What privilege is needed for a user to delete rows from tables in another schema?
How do I spool in oracle?
what is insert all statement in sql
defination of bitmap index
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Explain integrity constraints?
What is max rowid in oracle?
What privilege is needed for a user to connect to oracle server?
What is a system tablespace?
What is user managed backup in Oracle?
How to call a sub procedure?
Explain about integrity constraint?
How to update values on multiple rows in oracle?
