Difference between join and a subquery?
- 8 Answers
- 45577 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
How to write a left outer join with the where clause in oracle?
How to put more than 1000 values into an oracle in clause?
Design database draw er diagram for a certain scenario ?
How to use values from other tables in update statements using oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is oracle latest version?
How to start an oracle instance?
How to select all columns of all rows from a table in oracle?
