# 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