Database Analyst Question:

Download Job Interview Questions and Answers PDF

Please explain what is the difference between UNION and UNION ALL?

Database Analyst Interview Question
Database Analyst Interview Question

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?