Database Analyst Question:
Please explain what is the difference between UNION and UNION ALL?
Answer:
UNION will omit duplicate records, whereas UNION ALL will include duplicate records. UNION requires the server to do the additional work of removing any duplicates.
| Previous Question | Next Question |
| Tell me what is the IN operator? | Explain me about a time when you could not meet a deadline? |