Re: [SQL] new table with a select

[MIkhail Puzanov]

Hi,


2011/8/25 <pp...@sapo.pt>

> Hello to all,
>
>
> Can anybody tell me the sql instruction to create a new table with a select
> of other table?
>
> I need to create a new table based on paralell of a table of lines. Can
> anybody post to me a example?
>
>
CREATE TABLE t AS
SELECT * FROM x;