title: SQL How to Update only first Row
body: <p>I'm working with PostgreSQL.
  I have table with some elements. In last column there is 'Y' or 'N' letter. I need command which Select only first that match (I mean where last column is 'N') and change it on 'Y'.</p>
  
  <p>My idea:</p>
  
  <pre><code>UPDATE Table SET Checked='Y' 
  WHERE (SELECT Checked FROM Table WHERE Checked='N' ORDER BY ID LIMIT 1) = 'N'
  </code></pre>
  
  <p>But it changes 'N' to 'Y' in every row.</p>