Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 45346 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 is oracle thin client?
Query to retrieve record for a many to many relationship ?
What are the different types of modules in oracle forms?
What is materialized view in Oracle?
What do you mean by merge in oracle?
How to increment dates by 1 in oracle?
How to define a procedure inside another procedure?
How to see the table columns used in an index?
What is the difference between primary key and unique key and foreign key in oracle?
How do I manually create a database in oracle?
How to fetch the row which has the max value for a column?
How to update values in a table in oracle?
How to connect to oracle using service name instead of sid?
How do I call oracle stored procedures that take no parameters?
what is the scripts in data base?
