How to use an aggregate function in a case statement of UPDATE statement. Thread starter dfmutz84; ... I am not new to SQL but neither an expert and I had not heard of this before.