title: How do I delete one record matching some criteria in SQL? (Netezza)
body: <p>I've got some duplicate records in a table because as it turns out Netezza does not support constraint checks on primary keys. That being said, I have some records where the information is the exact same and I want to delete just ONE of them. I've tried doing</p>
  
  <pre><code>delete  from table_name where test_id=2025 limit 1
  </code></pre>
  
  <p>and also</p>
  
  <pre><code>delete  from table_name where test_id=2025 rowsetlimit 1
  </code></pre>
  
  <p>However neither option works. I get an error saying </p>
  
  <pre><code>found 'limit'. Expecting a keyword
  </code></pre>
  
  <p>Is there any way to limit the records deleted by this query? I know I could just delete the record and reinsert it but that is a little tedious since I will have to do this multiple times.</p>
  
  <p><strong>Please note that this is not SQL Server or MySQL.This is for Netezza</strong></p>