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

How to return an array from java to pl/sql?

1110

Explain raise_application_error.

1077

Explain the purpose of %type and %rowtype data types with the example?

973

Explain select statements in sql?

1039

Which sorts rows in sql?

1000

What is data manipulation language?

1171

What does fetching a cursor do?

1066

What do you think about pl/sql?

1000

How many types of indexes are there in sql?

972

Can we commit inside a trigger?

979

What is the current version of postgresql?

1044

What is the difference between view and stored procedure?

949

What is trigger in sql and its types?

1041

What is the use of & in pl sql?

1030

Does db2 use sql?

922