Difference between join and a subquery?
Answer Posted / rajasekhar
sub query: it is a query to get the answer for multiple questions
joins: it is used for getting the data from more then two tables
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to shutdown your 10g xe server from command line?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain the difference between a procedure and a function?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How to drop a stored function?
How to assign query results to variables?
What is the best way to do multi-row insert in oracle?
How different is ms access and oracle?
What are the tools for Oracle ?
What are the extensions used by oracle reports?
How to rename a tablespace in oracle?
what are bitmap indexes? How does they work?
What are the logical operations?
How do I spool in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.