title: How to get count of records month-wise from mysql table?
body: <p>I have a mysql table points like this</p>
  
  <pre><code>id | points | orderid | date
  1  | 10     | 1234    | 2014-01-14
  2  | 20     | 4321    | 2014-02-04
  3  | 10     | 1234    | 2014-01-13
  </code></pre>
  
  <p>I want to get count of records for unique orderids</p>
  
  <p>like if i want to fech total records for month of jan then result will be</p>
  
  <p><strong>1</strong> not 2 because i need to fetch records for unique orderids</p>