title: Move one exact row to top of all rows leaving all other ASCENDING
body: <p>Hello I wonder how can it be done in SQL server.</p>
  
  <p>My code doesn't work.</p>
  
  <pre><code>SELECT * FROM
  TABLE_NAME
  WHERE NAME = 'United Kingdom'
  ORDER BY Name
  </code></pre>
  
  <p>Here is the sample:</p>
  
  <p><a href="https://i.stack.imgur.com/iWu8c.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iWu8c.png" alt="enter image description here"></a></p>
  
  <p>And here is expected result:</p>
  
  <p><a href="https://i.stack.imgur.com/qhCTv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qhCTv.png" alt="enter image description here"></a></p>
  
  <p>Thank you for your help.</p>