What is the purpose of the UNION operator in SQL, and how does it differ from the UNION ALL operator? - Study24x7
Social learning Network
Ashish Verma
21 Mar 2024 10:20 AM study24x7 study24x7

What is the purpose of the UNION operator in SQL, and how does it differ from the UNION ALL operator?

A

UNION and UNION ALL are interchangeable and produce the same results

B

UNION combines and returns distinct rows from multiple SELECT statements, while UNION ALL returns all rows, including duplicates

C

UNION is used for text data, while UNION ALL is used for numeric data

D

UNION ALL combines and returns distinct rows from multiple SELECT statements, while UNION returns all rows, including duplicates

Mobile Technologies Computer Programming Web Development
Like Comment Share
study24x7
Write a comment
Related Questions
500+   more Questions to answer

Get the App

Download the Study24x7 App, so you can connect and collaborate.

study24x7
study24x7
Most Related Articles