What is the purpose of the SQL CASE statement?

A. To filter rows based on a condition

B. To perform conditional logic within a query

C. To create a new table

D. To join tables based on a condition

Correct Answer is :

B. To perform conditional logic within a query