SQL Database Concepts Question:

Download Job Interview Questions and Answers PDF

Explain what is the difference between UNION and UNION ALL?

Basic SQL Server Interview Question
Basic SQL Server Interview Question

Answer:

UNION selects only distinct values whereas UNION ALL selects all values and not just distinct ones.

UNION: SELECT column_names FROM table_name1
UNION
SELECT column_names FROM table_name2
UNION All: SELECT column_names FROM table_name1
UNION ALL
SELECT column_names FROM table_name2

Download Basic SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
Can you explain what are COMMIT and ROLLBACK in SQL?Tell me what is a Linked Server?