What is the difference between join and union.

Answer Posted / vijay kulkarni

In Join, matching rows are joined side-by-side to make the
result table but whereas in Union rows are joined one-below
the other to make the result table.

Is This Answer Correct ?    21 Yes 33 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is null in pl/sql?

626


What are system versioned tables?

553


How to start the command-line sql*plus?

566


What is the difference between mdf and ndf files?

573


How can we find duplicate records in a table?

514






What is left join in postgresql?

544


What is sql injection vulnerability?

494


What are the differences between implicit and explicit cursors?

521


What are the two types of periodical indexes?

505


What is 19 null in sql?

535


What is the difference between unique and primary key constraints?

588


What is db journal file?

520


What is a record in a database?

563


Is sql microsoft?

547


Define concurrency control. : Transact sql

587