Database Analyst Question:
Download Questions PDF

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.

Download Database Analyst Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what is the IN operator?Explain me about a time when you could not meet a deadline?