Interviewer And Interviewee Guide

Database Analyst Interview Question:

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

Submitted by: Muhammad
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.
Submitted by: Muhammad

Read Online Database Analyst Job Interview Questions And Answers
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.