Problem of max(count(*))

Can someone tell me why the following sql statement cannot retrieve the maximum count of the record:

SELECT col, max(count(*)) FROM table
GROUP BY col

And also, can I use one sql statement to retrieve the maximum count of the record? If not, how?

Thank you more!! Received on Thu Oct 02 2003 - 01:00:54 CDT