Logic and control

We will look at three different sets of functions that will help us deal with logic and control issues.

IFC and IFN

There are also specific functions that return a value based on a condition that mirrors the IF and THEN capability we used earlier in the LAG example. The IFC and IFN functions are quite useful as they help the coding to be quite compact while delivering the required result. This helps reduce the processing time and debugging, if required. We will revisit the COALESCE function to showcase the IFN and IFC functions. The only difference between them is that the IFN function expects numeric arguments and resolves to a number, whereas the IFC function can take the first argument as numeric but expects...