title: max count for count(*)
body: <p>My table structure is </p>
  
  <pre><code>| Field      | Type      | Null | Key | Default           | Extra |
  | uid        | char(255) | NO   |     |                   |       |
  | lid        | char(255) | NO   | MUL |                   |       |
  | ip_address | char(15)  | NO   |     |                   |       |
  | user_agent | char(255) | YES  |     | NULL              |       |
  | open_date  | timestamp | NO   | MUL | CURRENT_TIMESTAMP |       |
  | referrer   | char(255) | YES  |     | NULL              |       |
  | environ    | text      | YES  |     | NULL              |       |
  | country    | char(255) | NO   | MUL |                   |       |
  </code></pre>
  
  <p>I want to query for max clicks recored in a particular day of a month </p>
  
  <p>Query</p>
  
  <pre><code>select count(open_date) as c,day(open_date) as d
  from link_click 
  where month(open_date)="01" and year(open_date)="2011" 
  group by d
  having c =MAX(c);
  </code></pre>
  
  <p>but it's resulting empty set.</p>
  
  <p>Pls. suggest.</p>