what is the difference between union and union all
- 14 Answers
- 43991 Views
- IBM, Luxoft, Oracle, I also Faced
- E-Mail Answers
Answer Posted / ajith
A UNION statement eliminates duplicate rows;
A UNION ALL statement includes duplicate rows.
| Is This Answer Correct ? | 37 Yes | 4 No |
Post New Answer View All Answers
What is the sql*loader? : aql loader
What are the types of index in sql?
Write a sql query to find the names of employees that begin with ‘a’?
Is inner join same as self join?
what is sub-query? : Transact sql
What is a temporal data type?
What packages are available to pl/sql developers?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What sql does db2 use?
What is a primary key example?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What plvcmt and plvrb does in pl/sql?
How do I remove sql developer from windows 10?
how to use regular expression in pattern match conditions? : Sql dba
Can we call dml statement in function?
