Majority

Description

Works on an attribute and returns the value that is greater than 50% of the rows in that attribute.

Syntax

Majority ( attribute )

Arguments

n is a numeric, string, or temporal expression.

Example

This query returns the continent attribute value as Majority; that is, it returns the continent that is listed in more than 50% of the rows. If no such value found then it returns null. 

select Majority(continent) as major_continent from world

Remarks

See also http://en.wikipedia.org/wiki/Majority.