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 tns file?
What is background process in Oracle?
what is dynamic SGA and static SGA
Explain the characteristics of oracle dba?
How to list all user accounts in oracle?
What is the disadvantage of User defind function?
Explain temporal data types in oracle
Write a syntax for update query in oracle?
How to recover a dropped table in oracle?
What is the difference between translate and replace in oracle?
Which environment variables are absolutely critical in order to run the OUI?
What is a sub query? What are its various types?
How a database is related to tablespaces?
how can we store any pdf file in oracle
Explain what are the advantages of views?