title: Select distinct a row in Mysql
body: <p>I have a database where I have two columns like you can see above.
  Note that the second line is equal to the first but the third is different as you can see</p>
  
  <pre><code>number_chip| Date_of_Scanned_chip
     345             2016-12-12
     345             2016-12-12
     345             2017-1-03 
  </code></pre>
  
  <p>The DISTINCT on the column (number_chip) eliminates all the chips and gives me only one</p>
  
  <pre><code>   number_chip| Date_of_Scanned_chip
         345             2016-12-12
  </code></pre>
  
  <p>But I want something that gives me this. Please help :)</p>
  
  <pre><code>number_chip| Date_of_Scanned_chip
         345             2016-12-12
         345             2017-1-03 //Eliminates the second line
  </code></pre>