title: How to get the top record from SQL Server Compact Edition?
body: <p>I've tried</p>
  
  <pre><code> select top 1 * from tbl
   select top(1) * from tbl
   select * from tbl limit 1
  </code></pre>
  
  <p>Nothing worked.</p>
  
  <p>Does SQL Server Compact Edition support getting the top x rows?</p>