Re: SQL question

From: Hui, Kwok Miu <huikomix_at_dt.com.hk>
Date: 1996/11/14
Message-ID: <328BDAD4.7F18_at_dt.com.hk>#1/1

pfinn_at_creighton.edu wrote:

>

> Here's an example of what I'm doing. I'm trying to pull an update off to
> modify one _and_only_one_ occurrence of another field.
>
> Now using a regular update scheme, all amounts will be updated wherever a
> a date of 11/12/96 is found.

 update table_1 set

    amount=:your_amount
    where date=:your_date and rownum=1;

-- 
Hui, Kwok Miu: Oracle DBA & Unix Administrator
               Cho Yang (Hong Kong) Co., Ltd.
email: huikomix_at_dt.com.hk
Tel  :(00852)2589 3369

Received on Thu Nov 14 1996 - 00:00:00 CET