title: SQL update top1 row query
body: <p>The query below is working:</p>
  
  <pre><code>update  top(1) ShipBillInfo 
  set     shipfirstname='kkk' 
  where   CustomerId='134';
  </code></pre>
  
  <p>but it is showing error if i try to order by some Id: for example:</p>
  
  <pre><code>update  top(1) ShipBillInfo 
  set     shipfirstname='kkk' 
  where   CustomerId='134' 
  order by 
          OredrGUID desc;
  </code></pre>