SQL | IIF Function | Learn a Shorthand for CASE #shorts

SQL Tips - Do you sometimes get tired of writing the long CASE statements?

Do you ever wish to know a shorthand way to write the CASE function?

Well, yes, there are functions which which can be used as a shorthand for CASE.
One such function is the IIF function. Do you know any others?

Please make sure to comment below!!!

this is really awesome

Very nice!

which version its supported?

Excellent 👌 and any stuff completely on advance sql? Please let us know

good advice, not applicable for Oracle