What are various joins used while writing SUBQUERIES?
- 2 Answers
- 3539 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to find the duplicate rows count from employees table in oracle?
What is materialized view in Oracle?
6. Display the client name and order date for all orders using the traditional method.
What is key preserved table?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to use values from other tables in update statements using oracle?
How do you find current date and time in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
definition of cluster and non-clustered index?
Explain overloading. Can functions be overloaded?
What are the execution control statements in oracle?
When do you get a .pll extension in oracle? Explain its importance
What are the system predefined user roles?
How to check the oracle tns settings?
