SQL Mode is a Function that returns the frequent occurring value of a numeric expression. When there are no duplicate values in the records, the mode returns NA.
Understand with Example
To understand the example we use the following query that include a set of string value in a normal mode. The Query result in 0 (false for the condition), when the 1 is not present between -5 and 5. Otherwise it returns 1 (true for the condition), if it exists between -5 and 5.