What are various joins used while writing SUBQUERIES?
- 2 Answers
- 3486 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nishi
Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though they don't satisfy the join condition.
Equi-join--Its a join condition that retrieves rows from one or more tables in which one or more columns in one table are equal to one or more columns in the second table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / basanti
Joins and subquery both are different.
We don't use joins while writing subqueries.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is exact difference between drop and truncate table.
What is Index and different types of Indexes?
How to use like conditions in oracle?
Is it possible to enter only time value into a column of a table in sql?
How to use group functions in the select clause using oracle?
difference between imlicit cursor and explicit cursor ?
Explain what are the characteristics of data files?
What are ACID properties in databases?
How to omit columns with default values in insert statement in oracle?
What is a View ?
How to call a stored procedure inside a trigger? Give an example.
Explain the use of indexes option in imp command.
Oracle General 
