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!!

"Alex" <ricky.chen (AT) i-cable (DOT) com> skrev i en meddelelse
news:blgftc$pi8$1 (AT) news (DOT) hgc.com.hk...

Please cross-post rather than posting the same query twice. See my answer in
comp.databases.


--
Kristian Damm Jensen
damm (at) ofir (dot) dk