sql how to show row with same column value only once
<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>