I have a query result like this
id | code | data
1 | b001 | 12
1 | b001 | 13
1 | b001 | 15
2 | b002 | 20
2 | b002 | 15
2 | b002 | 10
i want to change the data value into 12 and 20 for every different id like this :
id | code | data
1 | b001 | 12
1 | b001 | 12
1 | b001 | 12
2 | b002 | 20
2 | b002 | 20
2 | b002 | 20
You need to use first_value window function
Add this to your SELECT:
(first_value(data) OVER (PARTITION BY id)) as data