A. To concatenate two or more strings
B. To combine the results of two or more SELECT statements
C. To join tables based on a condition
D. To filter out NULL values from the result set

Solution

B. To combine the results of two or more SELECT statements