Difference between join and a subquery?
Answer Posted / 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 |
Post New Answer View All Answers
What is a data dictionary and how can it be created?
What is parameterized cursor in oracle?
What is the difference between sharding and replication?
How to view all columns in an existing table?
How to rename a column in an existing table?
query optmization techniques and quwry analyser+projects+ppts
How to load a large xml file?
Can multiple columns be used in group by in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
What is snapshot is too old? Give and example for better understand.
What are the different types of failures that occur in Oracle database?
How to update values in a table in oracle?
Why does oracle 9i treat an empty string as null?
How do I escape a reserved word in oracle?
How to insert a record into a table?