title: How to find duplicates in a table using Access SQL?
body: <p>I try to use an SQL query in Access but it doesn't work. Why?</p>
  
  <pre><code>SELECT * FROM table
  EXCEPT
  SELECT DISTINCT name FROM table;
  </code></pre>
  
  <p>I have a syntax error in FROM statement.</p>