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 does the sign mean in sql?

989

What is the use of nvl function?

1198

What is loop in pl sql?

1037

How does one load ebcdic data? : aql loader

1171

State some properties of relational databases?

1056

What does desc stand for?

1069

What are the packages in pl sql?

1010

Define tables and fields in a database

1130

what are the authentication modes in sql server? How can it be changed? : Sql dba

1431

what is table? : Sql dba

1062

Differentiate pl/sql and sql?

1065

What is composite data type in pl sql?

1111

what is the difference between $message and $$message? : Sql dba

997

Who is the owner of mysql database?

1057

What is procedure explain with example?

961