This function returns the number of times the mode occurs (even in multi-modal populations).
|
V1 |
V2 |
V3 |
V4 |
V5 |
V6 |
|
5 |
25 |
2 |
25 |
25 |
30 |
With a resultset of the following six values (v1, v2, v3, v4, v5, v6), the multimodaloccur would be the 3, because the mode, 25, occurs three times.
|
V1 |
V2 |
V3 |
V4 |
V5 |
V6 |
|
5 |
25 |
8 |
7 |
25 |
8 |
In the above example, the multimodaloccur would be 2, because there is more than one value that repeats at the highest frequency (both 25 and 8), and they both repeat twice.
value_exp can be an expression of any SQL data type.