What is the difference between join and union.

Answer Posted / vinay shukla

A join selects columns from 2 or more tables.
a union selects rows

Is This Answer Correct ?    60 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of sql trace?

481


What is int identity in sql?

576


What is the difference between clustered and non-clustered indexes?

603


What are sql queries used for?

538


What is the difference between partition and index?

485






What is cross join sql?

504


What is trigger explain it?

551


What is varray in pl sql?

566


What is varchar used for?

538


Are sql connections encrypted?

560


What is difference between table and view?

527


how to use 'mysql' to run sql statements? : Sql dba

539


How does pl sql work?

528


What is %s in sql?

570


Can we rollback truncate?

544