What are various joins used while writing SUBQUERIES?
- 2 Answers
- 3126 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 |
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to start a new transaction in oracle?
How different is ms access and oracle?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
How to start an oracle instance?
Please explain oracle data types with examples?
what is the difference between data migration and production migration.
How to view the data files in the current database?
How do I uninstall oracle client from windows?
How can we Update a table with out using UPDATE command?
is database gud carrier option??
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Oracle General 
