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

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.....

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;

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.

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

Answer / diksha bhatia

the given answers is right

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;

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

What does ROLLBACK do ?

1 Answers  

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1 Answers   Sierra Atlantica,

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1 Answers   Wipro,

How to use attributes of the implicit cursor in oracle?

1 Answers  

What is a subquery?

1 Answers  

What is a cluster Key ?

2 Answers  

20. Using a set operator, display the client number of all clients who have never placed an order.

1 Answers   Wipro,

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1 Answers  

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 Answers  

Can we connect to ORACLE db using Windows Authentication?

1 Answers   MCN Solutions,

How would you best determine why your MVIEW couldnt FAST REFRESH?

1 Answers  

Does oracle database need java?

1 Answers