Thread: Unload of Data

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.

Regards

Brent Robertson
GIS Administrator
Hastings District Council
Phone: (06) 878-0500
FAX:    (06) 878-0586
EMAIL: brentr@hdc.govt.nz

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
--------------------------------------------------------------------------