Re: Unload of Data

On Thu, Dec 07, 2000 at 09:31:59AM +1300, brentr@hdc.govt.nz wrote:
> Hi
>
> How can I unload a small subset of data from a table ie
>
>  select * from rates
>  where propid = '12345'
>
> 1 Record of around 30000.

Is this what you want?

delete from rates where propid='12345'


HTH,

Albert.



--

--------------------------------------------------------------------------
Albert Reiner                                   <areiner@tph.tuwien.ac.at>
Deutsch       *       English       *       Esperanto       *       Latine
--------------------------------------------------------------------------