Hello,hru, I have a table data as below:
Item
pepsi
pepsi
orange
fanta
orange
fanta
fanta
orange
pepsi
pepsi
pepsi
i want to count and get the maximum data, which is pepsi in this case, how should i do in mysql.
Any help will b appreciated
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --