Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32913 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna alla
Above one is exact answer that says sub query is used to get data based on unknown condition (example: select the employee's salary where employee salary greater than clerk) here first we find out clerk salary and then based on his salary we find employee's salary according to above query)
join is used to get the data from atleast 2 tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use "if" statements on multiple conditions?
How to rename an index?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to export your own schema?
How to start a specific oracle instance?
what is port in oracle? how is it related to database application.
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
Is primary key indexed by default in oracle?
defination of bitmap index
What is meant by raw datatype?
Explain what are the different type of segments?
What is connection pooling in oracle?
Can we write insert statement in function in oracle?
How to call a stored function with parameters?
