Create Copy of Table with Subset of Rows

#11

Paul Rowe wrote:

Quote:

Yes - that's the exact SQL. But I'm using 9.0.0.1108 -
could that be the difference?

9.0.1+ - see answer from Richard Biffl.

Dmitri.

#12

Quote:

Paul Rowe wrote:

Yes - that's the exact SQL. But I'm using 9.0.0.1108 -
could that be the difference?

9.0.1+ - see answer from Richard Biffl.

Dmitri.

So what was the correct method to use prior to 9.0.1??

Paul

#13

Paul Rowe wrote:

Quote:

So what was the correct method to use prior to 9.0.1??

create table tab1
(
....
) ;

insert into tab1
(
select ...
from tab2
where ...
) ;

Dmitri.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Create Copy of Table with Subset of Rows

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Re: Create Copy of Table with Subset of Rows - 04-06-2006 , 05:29 AM

Re: Create Copy of Table with Subset of Rows - 04-06-2006 , 07:13 AM

Re: Create Copy of Table with Subset of Rows - 04-06-2006 , 07:27 AM