Genpact interview question

What is conditional aggregation in SQL?

Interview Answer

Anonymous

Dec 20, 2023

We have learned the concept of Aggregate function in Learn SQL, that it gives a single output value based on the calculation on multiple input values. Now, lets learn the concept of Conditional Aggregate function. In this concept we add a set of condition to the existing Aggregate functions.