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
What is null value in oracle?
Explain oracle’s server parameter file.
What privilege is needed for a user to create indexes in oracle?
How to get last row id?
What is different types of joins?
Can you tell me how to add new column in existing views?how?How is possible?
Can we save images in a database and if yes, how?
Why do we need integrity constraints in a database?
How to store only time; not date and time?
How to create tables for odbc connection testing?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How do I escape a reserved word in oracle?
How can I see all tables in oracle?
What are the types of trigger in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.