A UNION statement eliminates duplicate rows; A UNION ALL statement include

what is the difference between union and union all

Question Posted / ajith

Answer Posted / ajith

A UNION statement eliminates duplicate rows;
A UNION ALL statement includes duplicate rows.

Is This Answer Correct ?

37 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the cause of mutating table error and how can we solve it?

606

How do I view a table in sql?

547

what are the advantages of mysql in comparison to oracle? : Sql dba

533

Which constraints we can use while creating database in sql?

619

What is loop in pl sql?

578

What is difference between hql and sql?

516

What are sql ddl commands?

552

what is 'mysqladmin' in mysql? : Sql dba

538

How do I count records in sql?

522

What is the left table in sql?

523

How do you declare a user-defined exception?

534

Does sql backup shrink transaction log?

563

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

811

What is the difference between inner join and left join?

550

what are date and time data types? : Sql dba

542