Finding latest record from duplicates : I have a customers table with ID's and some date/time columns. But those ID's have duplicates and i just want to Analyse distinct values. 
I tried using groupby but this makes the process very slow.
Due to data sensitivity can't share it.
Any suggestions would be helpful.