title: Omit duplicate values in one column and show the rest
body: <p>I am starting with SQL, so my question will be easy for you.</p>
  <p>I have <strong>one table</strong> with many columns. Most important are [Test number] and [Start time]. [Test number] contains many duplicated rows and [Start time] contains always unique records. And now I want to show in results all table columns, where only the [Test number] with maximum [Start time] will be used.</p>
  <p>I was able to create one result regarding the maximum [Start time]</p>
  <pre><code>SELECT MAX([Start time])
  FROM [Testing_ADB_Overview].[dbo].[HTT_DB]
  GROUP BY [Test number]
  ORDER BY MAX([Start time])
  </code></pre>
  <p>but I do not know how can I apply it to see in results all the other columns. Can you please help me?</p>
  <p>MF</p>