what is the main difference between join and subqurey?
Answer Posted / 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 |
Post New Answer View All Answers
Which is faster union or join?
what are the performance and scalability characteristics of mysql? : Sql dba
What is keys and its types?
Is time a data type in sql?
What is sap sql?
What is offset and limit in sql?
How many types of triggers are there in pl sql?
What is trigger and how to use it in sql?
How would you pass hints to the sql processor?
Which is faster joins or subqueries?
how many triggers are allowed in mysql table? : Sql dba
What are the advantages of pl sql?
What is the purpose of the primary key?
what is an index? : Sql dba
Why is pl sql needed?