|Functions / Aggregation Functions|
Works on an attribute and returns the value that is greater than 50% of the rows in that attribute.
Majority ( attribute )
n is a numeric, string, or temporal expression.
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
See also http://en.wikipedia.org/wiki/Majority.