complex update statement
I want to update this table based on a rather complex logic in terms of what UPDATE can handle - as far as I know...
The table ("example") design:
id MEDIUMINT UNSIGNED
user_id MEDIUMINT UNSIGNED
isarchived TINYINT UNSIGNED
more_data_cols...
1) i set them ALL to isarchived = 1
2) per DISTINCT user_id, i want ONLY 1 row to be isarchived = 0.
how do I go about doing that?
Thanks so much!
Subject
Views
Written By
Posted
complex update statement
2900
November 16, 2009 01:31PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.