what is the difference between union and union all
- 14 Answers
- 43866 Views
- IBM, Luxoft, Oracle, I also Faced
- E-Mail Answers
Answer Posted / anjani kumar
Union will return only distinct values from two tables.
Union all will return duplicate values from the two tables
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What is pragma in pl sql?
What is embedded sql in db2?
What is server name sql?
What is type and rowtype in pl sql?
What is constant in pl sql?
Explian rowid, rownum? What are the psoducolumns we have?
What is snowflake sql?
What is a table in a database?
what is auto increment? : Sql dba
What is the difference between microsoft access and sql?
what are the different tables present in mysql? : Sql dba
What found sql?
What is Histogram?
What is sql architecture?
Why do we use joins in sql?
