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