title: See whether an item appears more than once in a database column
body: <p>I want to check if a piece of data appears more than once in a particular column in my table using SQL. Here is my SQL code of what I have so far:</p>
  
  <pre><code>select * from AXDelNotesNoTracking where count(salesid) &gt; 1
  </code></pre>
  
  <p><code>salesid</code> is the column I wish to check for, any help would be appreciated, thanks.</p>