to find statistical value?

[hodgson]

hello all,
For a large dataset in a table, I have to find statistical values, including top and bottom ranges, means, and modes. I can use MIN() and MAX(), and for means, there is AVG(). How can I do this within mysql?
Thanks -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Kodi]

SELECT name, count(name) as count
FROM names
GROUP BY name
ORDER BY count DESC
LIMIT 0,1; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --