I need to limit the number of rows that an update statement affects.
Most resources on the web that i have seen suggests:
Expand|Select|Wrap|Line Numbers
- UPDATE (SELECT ...) SET ... WHERE ..
I'm stuck with this problem for 2 days already and I am hoping someone can help me with this.
Thanks in advance.
Note: The table to be updated changes dynamically so i can't use primary keys or any specific column