title: Retaining higher value and deleting lower value in SQL
body: <p>Happy New Year.</p>
  <p>I am unsure how to do an SQL where I need to retain the record for clientID with the highest level while deleting the others?</p>
  <p>My Table is like below</p>
  <p><a href="https://i.stack.imgur.com/CrLk4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CrLk4.png" alt="Table" /></a></p>
  <p>And would like to have below</p>
  <p><a href="https://i.stack.imgur.com/3njwA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3njwA.png" alt="enter image description here" /></a></p>
  <p>Basically, it removes the duplicate clientID row but retain the highest level of that clientID record.</p>
  <p>Thank you for any guidance.</p>