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
What is pl/sql table? Why it is used?
what are the advantages of using stored procedures? : Sql dba
Can a commit statement be executed as part of a trigger?
How can we find duplicate records in a table?
What is microsoft t sql?
What schema means?
What are the advantages of normalization?
What is flag in sql?
how mysql optimizes distinct? : Sql dba
What are the parameter modes supported by pl/sql?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is parameter substitution in sql?
what is log shipping? : Sql dba
What are sql built in functions?
Can a table have no primary key?