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

What is materialized view in sql?

875

How many types of index are there?

962

How many types of triggers are there in pl sql?

1016

Is join an inner join?

898

What do you understand by pl/sql cursors?

1019

How to add, remove, modify users using sql?

980

Can we create view in stored procedure?

910

what is myisam? : Sql dba

1001

What is record data type?

861

Explain what is sql?

1061

What is the file extension for sql database?

939

Are dml statements autocommit?

987

what is data manipulation language? : Sql dba

949

How to assign sql query results to pl sql variables?

995

How can you load multi line records? : aql loader

1022