SQL function

Posted on In

 

1. IF()

The If function returns different values based on the condition.

1
IF(condition, value_if_true, value_if_false)

example: 

1
IF(mem.score is null, 0, mem.score)