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 / suresh

Answer Posted / suresh

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 ?

175 Yes

12 No

Please Help Members By Posting Answers For Below Questions

Which is better trigger or stored procedure?

1015

What can I use instead of union in sql?

1022

How does a self join work?

1234

What is rank function in sql?

1071

What is compound trigger?

1098

What does fetching a cursor do?

1133

When can we use the where clause and the having clause?

1085

How do you define a foreign key?

1064

What is multiple partition?

1019

What is record variable?

1042

What is null in pl/sql?

1121

What is a rank in sql?

1007

How to get each name only once from an employee table?

1159

What are different types of indexes?

1057

What is the starting oracle error number?

1098