what is the main difference between join and subqurey?
Answers were Sorted based on User's Feedback
Answer / ravi
all join may be sub query , but sub-query never be join
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ankush
A subquery is a query within a query.
A join is used to combine rows from multiple tables (2 or
more tables).
Its also can be done within a single table.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / udayselva
Subquery returns only one row and Join return More than one rows
Is This Answer Correct ? | 0 Yes | 6 No |
What is forward declaration in pl sql?
What are basic techniques of indexing?
What is the difference between subquery and correlated query?
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
Explain the types of joins in sql?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
Sql technical questions
Explain the structure of pl/sql in brief.
Write the order of precedence for validation of a column in a table ?
What is a transaction?
When should I use nosql database?
What is sql keyword?