title: how i group all row data by months and not eliminate with some date using group by
body: <p>i`m having a hard time trying to group all row data by dates.
  this is my table</p>
  
  <pre><code>id     date       Company
  ---|----------|-------------
   1 |2017-06-25|   Inzpect
   2 |2017-07-04|   Inzpect  
   3 |2017-06-25|   Meralco
   4 |2017-06-27|   Ginebra
   5 |2017-06-26|   Inzpect
  </code></pre>
  
  <p>and this is my sql</p>
  
  <pre><code>SELECT date ,company FROM tbl_reports WHERE YEAR(date) = '2017' group by date
  </code></pre>
  
  <p>this is the result i get to my sql</p>
  
  <pre><code>    date       Company
  ------------|----------
   2017-06-25 |  Inzpect
   2017-06-26 |  Inzpect  
   2017-06-27 |  Ginebra
   2017-07-04 |  Inzpect  
  </code></pre>
  
  <p>why it does not get all the data from my table and eliminate 1 of my row</p>
  
  <p>the thing i want to get is i want to get all rows and group it by dates but it always elimante some row with the same date :/ . </p>
  
  <pre><code>   date       Company
  ------------|----------
   2017-06-25 |  Inzpect
   2017-06-25 |  Meralco
   2017-06-26 |  Inzpect  
   2017-06-27 |  Ginebra
   2017-07-04 |  Inzpect 
  </code></pre>
  
  <p>can you help me guys :( </p>