Problem of max(count(*))

From: Alex <ricky.chen_at_i-cable.com>
Date: Thu, 2 Oct 2003 14:00:54 +0800
Message-ID: <blgftc$pi8$1_at_news.hgc.com.hk>

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 - 08:00:54 CEST