title: sql how to show row with same column value only once
body: <p><a href="https://i.stack.imgur.com/CBhQp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CBhQp.png" alt="enter image description here" /></a></p>
  <p>This is my table.
  I need to write a query that shows all the records but when a project reaches 100% It shows the record for that project only once.
  so the result should be
  <a href="https://i.stack.imgur.com/bwkqg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bwkqg.png" alt="enter image description here" /></a></p>
  <p>USING SQL SERVER 2005</p>