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


Please Help Members By Posting Answers For Below Questions

Explain exception handling in pl/sql?

729


What is self-join and what is the requirement of self-join?

845


What is sql server and ase?

713


What are the different types of triggers?

777


Is progress software supports to ( pl/sql )?

719






What is duration in sql profiler trace?

774


How to raise user-defined exception with custom sqlerrm ?

865


What is on delete restrict?

721


What does the hierarchical profiler does?

755


How do you declare a variable in pl sql?

748


How do I save the results of sql query in a file?

711


How do temporal tables work?

694


Which nosql database is best?

681


What are different joins used in sql?

735


What is sql used for?

856