what is the difference between union and union all
- 14 Answers
- 43934 Views
- IBM, Luxoft, Oracle, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Is truncate ddl or dml?
What is rank () in sql?
How to check if a column is nullable before setting to nullable?
What sql does db2 use?
Explain exception handling in pl/sql?
What are secondary keys?
what is a materialized view? : Sql dba
What is the difference between row level and statement level trigger?
When is the update_statistics command used?
Why use triggers in sql?
What is sql basics?
What is the basic form of sql query?
how does a local variable is defined using t-sql? : Transact sql
Where is all the data on the internet stored?
What is the current version of postgresql?
