title: SQL remove duplicate rows when counting
body: <p>I have a select statement using count and since I am counting the rows instead of returning them how do I make sure that I do not get a duplicate value on a column?</p>
  
  <p>For Example</p>
  
  <pre><code>_table_
  fName     someField
  Eric       data
  Kyle       mdata
  Eric       emdata
  Andrew     todata
  </code></pre>
  
  <p>I want the count to be 3 because Eric is duplicated, is there a way to do that? My select is:</p>
  
  <pre><code>Select Count(*) From _table_ INTO :var
  </code></pre>
  
  <p>Thanks,</p>