title: SQL select rows but remove records with duplicated phone number
body: <p>I've got an Application table containing phone numbers.  I'm trying to select the top 10000 rows ordered by the ApplicationId descending (to get the latest apps) but I want to remove all the duplicate phone numbers.</p>
  
  <p>I've tried..</p>
  
  <pre><code>select distinct * from
  (select top 10000 Forenames, PhoneNumber
  from Application
  order by ApplicationId desc) AS Applications
  </code></pre>
  
  <p>Although this query sorts it by Forename ascending, ie no longer in ApplicationId order.</p>