Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 44828 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 the Tune Query
What are the execution control statements?
What is Redo Log Buffer in Oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Please explain compound trigger in oracle?
Explain the use of ignore option in imp command.
How to define a data source name (dsn) in odbc manager?
Give the different types of rollback segments.
What is a static data dictionary in oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is an oracle database?
How can we view last record added to a table?
What do database buffers contain?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain the use of indexes option in imp command.
