title: CREATE TABLE LIKE A1 as A2
body: <p>I want to create a new table with properties of an old table and without duplicates. I want to do something like this:</p>
  
  <pre><code>CREATE TABLE New_Users  LIKE Old_Users, 
  AS
  (SELECT * FROM Old_Users GROUP BY ID) ;
  </code></pre>
  
  <p>But the above is not working.  Can anybody modify it to work?</p>