Re: SQL question
From: David J. Roth <droth_at_sii.com>
Date: 1996/11/13
Message-ID: <01bbd159$a3c4d160$8b0ebe9b_at_droth.sii.com>#1/1
Date: 1996/11/13
Message-ID: <01bbd159$a3c4d160$8b0ebe9b_at_droth.sii.com>#1/1
try this;
update <table> set amount = new_amount
where rowid = (select min(rowid) from <table> where date = '12-nov-96');
-- David J Roth (My own opinions) pfinn_at_creighton.edu wrote in article <Pine.HPP.3.95.961112161231.4759A-100000_at_penguin.creighton.edu>...Received on Wed Nov 13 1996 - 00:00:00 CET
>
> Okay, I would really like help on this one. I tried using rowid's but
> that didn't seem to work.
>
> 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. Like this...
>
> DATE AMOUNT
> ---- ------
> 11/12/96
> 11/12/96
> 11/12/96
> 11/12/96
>
> Now using a regular update scheme, all amounts will be updated wherever a
> a date of 11/12/96 is found. How can I pull it off so that it will only
> update one of those records (I don't care which one, really). Again, I
> tried using rowid, but perhaps my syntax wasn't correct.
>
> Appreciate it.
>
>