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 worldRemarks
See also http://en.wikipedia.org/wiki/Majority.