title: SQL: Eliminate duplicate entries by selecting ID but showing Name instead
body: <p>How can I select by (ID) but still show distinct (Name) by the newest (Mod.Date) to eliminate the duplicates in the (Name) column. I'm assuming this is easy but i've never done this. Thank you</p>
  
  <p><img src="https://i.stack.imgur.com/wMnp6.png" alt="enter image description here"></p>