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
number_chip| Date_of_Scanned_chip
345 2016-12-12
345 2016-12-12
345 2017-1-03
The DISTINCT on the column (number_chip) eliminates all the chips and gives me only one
number_chip| Date_of_Scanned_chip
345 2016-12-12
But I want something that gives me this. Please help :)
number_chip| Date_of_Scanned_chip
345 2016-12-12
345 2017-1-03 //Eliminates the second line