Give an example of a business problem solved using a case statement. Give an example for a business problem solved with an IF statement. Can IF statements replace SELECT statements, why or why not?© BrainMass Inc. brainmass.com April 1, 2020, 1:33 pm ad1c9bdddf
1. Case Statement:
Behavior: When a particular case is met, then it replace the formulea or value in the putput parameter
Business Problem: Calculate the average VOC ratings for the vendor performance for inside SLA and outside SLA?
For the above business problem, case statement is best suited, if the DB captures ...
Examples of case statements are presented.