title: How to delete duplicate rows based on one column in postgreSQL?
body: <p>Say I have column A, B and Date, and I want all rows which are duplicated in A to be removed, while keeping the one with the most recent Date. How would I do this?</p>
  
  <p>I have looked at many other solutions but none seem to work for my case.</p>
  
  <p>Thanks in advance for any help</p>