title: How to write SQL to pull latest not null data from multiple rows using group by function?
body: <p>I want to write SQL for MS SQL to pull  the latest records of each column for each <code>number</code></p>
  <p>This is how data looks like:</p>
  <p><a href="https://i.stack.imgur.com/TQVjX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TQVjX.png" alt="enter image description here" /></a></p>
  <p>This is how I want my output:</p>
  <p><a href="https://i.stack.imgur.com/KugTE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KugTE.png" alt="enter image description here" /></a></p>
  <p><strong>UPDATE:</strong></p>
  <p>Also, will it make any better if i change my INSERT statement and include the TYPE Column, Can I take the latest record of each TYPE and run any aggregate function (MIN/MAX) ? :</p>
  <p><a href="https://i.stack.imgur.com/G5t35.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/G5t35.png" alt="enter image description here" /></a></p>