union is used to select distinct values from two tables where as union al

what is the difference between union and union all

Question Posted / ranjay kumar singh

Answer Posted / ranjay kumar singh

union is used to select distinct values from two tables
where as union all is used to select all values including
duplicates from the tables

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

988

What does the file extension accdb stand for?

919

What are database links used for?

994

Does truncate table reset auto increment?

941

What is materialized view in sql?

875

What is the difference between union and union all command?

1009

What is difference between sql and oracle?

1050

What is sql basics?

992

How do I create a sql database?

950

Can we use having without group by in sql?

929

What is difference between rank () row_number () and dense_rank () in sql?

1052

What are different types of sql commands?

1025

What does truncate mean in sql?

964

Why do we need cursors in pl sql?

1004

What are stored procedures in mysql?

971