title: Sql Server CE can I delete TOP or only 1 record from table that matches my query
body: <p>select Top(1)* from TableName Where columnName=value</p>
  
  <p>selects only the first row just fine.  However if I change the select to a delete I get an error and can't figure out how to write a query to delete only 1 record that matches my query from the db. </p>
  
  <p>I'm wondering if anybody out there smarter than I knows if or how this can be done in SQL CE.</p>