Difference between join and a subquery?
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 difference between pre-select and pre-query?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to define a data source name (dsn) in odbc manager?
Explain temporal data types in oracle
What is ceil and floor in oracle?
Explain what are the different type of segments?
What is parameterized cursor in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is primefaces used for?
Explain the use of rows option in imp command.
Can we store images in oracle database?
What are the different types of synonyms?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How translate command is different from replace?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.