MODE

The MODE function returns the most common value in the selected column. If there are no repeating values, or if there is the same frequency of multiple values, this function returns the top value based on the ORDER BY clause.

The MODE function is commonly used with the following functions:

Syntax

The following is the correct syntax for the MODE function:

MODE() WITHIN GROUP (ORDER BY column)

Example

The example in this section is based on the players table below:

Player_Name Team Score
T_Tock Blue 13
N_Stein Blue 20
F_Dirk Blue 20
Y_Hyung Blue 10
A_Rodrick Blue 13
R_Evans Red 55
C_Johnston Red 20
K_Stoll Red 25
J_Loftus Red 22
L_Ellis Red 7
G_Elroy Red 23

The following is an example of the MODE function:

SELECT
MODE() WITHIN GROUP (ORDER BY score) as Mode
FROM players;

Mode|
----+
20