Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 45063 Views
- Base Automation, NMDC, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are dml statements in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to sort output in descending order in oracle?
Explain what are the type of synonyms?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Explain enable novalidate constraint.
State and explain about oracle instance?
How to initialize variables with default values?
what is the scripts in data base?
What do you understand by a database object? Can you list a few of them?
Who developed oracle & when?
What do you mean by group by clause?
How do you store pictures in a database?
What is difference between cartesian join and cross join?
What is a sub query? What are its various types?
