Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 45341 Views
- Base Automation, NMDC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
subquery can be used for simple logical queries , to get
required output/condition
but if you want to compare two or more tables and get output
in the way you want it would be lot difficult to manage all
those with subqueries - so we can use the concept of joins
| Is This Answer Correct ? | 39 Yes | 5 No |
Answer / maddy
Subquery is also query which returns one or more values we
can retriew the data based on the where contd="IN,ALL"...
subquery is the query followed by the main query....
join is used to join the two table is used to retriew the
data from 1 or more tables.....
| Is This Answer Correct ? | 27 Yes | 12 No |
Answer / neo devan
A query inside a query or next level query is called
subquery, a subquery can return 1 or more values to the
main query.
Ex: select * from emptable where deptno=(select deptno from
saltable where rownum=1);
A Join is used to query two tables, or views.
Ex: select * from emptable inner join saltable on
emptable.deptno=saltable.deptno;
| Is This Answer Correct ? | 18 Yes | 7 No |
Answer / bhuvana
Joins-
1.Want to combine and fetch data from more than 2 tables.
2.Joins are faster, efficient, easy to understand and better performance.
Subquery-
Want to combine and fetch data from a pair of table.
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / katty
When data is to be retrieved from one table based on the condition from another table subquery is used
When the data is to be retrieved from both the tables join is used
| Is This Answer Correct ? | 10 Yes | 5 No |
Answer / ashi
Sub query: The sub query has more than one select
statement,the inner query which executes first and then it
will be the value of the 2nd query.
EX:
select ename from emp where sal>(select avg(sal) from emp);
Joins:
When the data from more than one table in the database,then
a join condition used.Rows in the one table can be joined to
rows in the other table according ro the common values
existing in corresponding columns
EX:
select dname,ename from emp,dept where emp.deptid=dept.deptid;
| Is This Answer Correct ? | 9 Yes | 5 No |
Answer / rajasekhar
sub query: it is a query to get the answer for multiple questions
joins: it is used for getting the data from more then two tables
| Is This Answer Correct ? | 4 Yes | 2 No |
What is varray?
what is the use of composite key constraint?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
What is dual table oracle?
How many categories of data types in oracle?
Can multiple columns be used in group by in oracle?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
What is the difference between a primary key & a unique key?
What is instant client oracle?
Does oracle database need java?
What is a read only transaction in oracle?
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
Oracle General 
