mode
This section contains reference documentation for the mode function.
Get the most frequent value in a group. When multiple modes are present it gives the minimum of all the modes. This behavior can be overridden to get the maximum or the average mode.
MODE(colName, [reducerType])
select mode(yearID) AS value
from baseballStats
WHERE AtBatting != 0 AND yearID > 2001
value |
|---|
2008 |
select mode(yearID, 'AVG') AS value
from baseballStats
WHERE AtBatting != 0 AND yearID > 2001
value |
|---|
2010 |
select mode(yearID, 'MIN') AS value
from baseballStats
WHERE AtBatting != 0 AND yearID > 2001
value |
|---|
2008 |
select mode(yearID, 'MAX') AS value
from baseballStats
WHERE AtBatting != 0 AND yearID > 2001
value |
|---|
2012 |
Last modified 1yr ago