how about something like:
Code:UPDATE a SET myField = 'TRUE' WHERE myKeyVal in ( SELECT myKeyVal FROM a WHERE myGroup = 'xxx' AND rownum < 61 ORDER BY whatever_you_want_to_order_by)
|
Results 1 to 10 of 12
Threaded View
|
Click Here to Expand Forum to Full Width |