sql server 2008 - sql query with create command -

this question has answer here:

• try create table select - sql server 2008 throws error 4 answers

i having problem in creating table table. using query:

create table new_table ( select distinct * old-table) 

its giving error

incorrect syntax near keyword 'as'. 

select distinct * new_table  old-table  group whatever want group by

edit: can cast rows varchar, comparable, or can group column values want distinct.