Re: [sqlite] store result

[Jay Sprenkle]

On 1/19/06, manoj marathayil <[EMAIL PROTECTED]> wrote:
>
> hi,
> is there is any way so that i can store the result
> of
> a select query and execute a delete query on the
> same
> table with out using any other buffer?

How about:

select id
 into temp_table
 from source_table
where somecondition = true;

delete from source_table
where id in ( select id from temp_table );