Friday, 24 March 2017

Updating Netezza With Dummy Values

update data set a = sub.DummyValue
from (
Select id,
'HH'||row_number() OVER(ORDER BY id ) DummyValue  from data a 
) sub
where data.id = sub.id;

No comments:

Post a Comment