title: mysql:how to get the count of unique records which has multiple groupby
body: <p>I need the count of the unique records like the following structure</p>
  
  <pre><code>DATE      | STATUS |  EMPLOYEE|UNIQUEDATE|UNIQUESTATUS|UNIQUEEMPLOYEE
  20-1-2013   active    John          7         3             2
  20-1-2013   active    John          7         3             2
  20-1-2013   active    Kyle          7         3             1
  20-1-2013   inactive  mohan         7         4             1
  20-1-2013   inactive  subbu         7         4             3
  20-1-2013   inactive  subbu         7         4             3
  20-1-2013   inactive  subbu         7         4             3
  </code></pre>
  
  <p>The count is based on the values of generated output</p>
  
  <p>I tried this query :</p>
  
  <pre><code>select DATE,STATUS,EMPLOYEE,COUNT(DATE) as DATECOUNT,COUNT(STATUS ) as DATESTATUS ,COUNT(EMPLOYEE) as DATEEMPLOYEE from dailyincome group by DATE,STATUS,EMPLOYEE
  </code></pre>
  
  <p>but the count are same for all the three columns.</p>