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
Show code of a cursor for loop.
what are the properties and different types of sub-queries? : Sql dba
what is text? : Sql dba
What is the need of merge statement?
Why left join is used in sql?
What is the use of partition by in sql?
Why stored procedures are faster than query?
Name the operator which is used in the query for pattern matching?
how to use in conditions? : Sql dba
What are functions in sql?
Can triggers stop a dml statement from executing on a table?
What are views in sql?
What is scalar function?
When are we going to use truncate and delete?
What does dml mean?