'Repeat a single row in all rows Oracle grouped
I need to repeat the car answer in all rows until the next survey set of answer.
The example I need is in the last column.
The need is with this way, I can create a car parameter filter to fetch all the answer rows.
I've tried some ways but no success.
Is that possible?
Thanks a lot for any help.
surv_id date_time question_id question answer_id answer car
CAR_CHECK1 30/03/2022 08:42 5169 type 4509 return to supplier RMN9H51
CAR_CHECK1 30/03/2022 08:43 5132 date_time 4624 2022-03-30-08.43.00 RMN9H51
CAR_CHECK1 30/03/2022 08:43 5174 car group 4629 V RMN9H51
CAR_CHECK1 30/03/2022 08:48 5134 car 4632 RMN9H51 RMN9H51
CAR_CHECK1 30/03/2022 08:48 5135 car km 4633 51389 RMN9H51
CAR_CHECK1 30/03/2022 08:48 5142 picture 4634 YES RMN9H51
CAR_CHECK1 30/03/2022 08:55 5166 signature 4627 SIGNATURE RMN9H51
CAR_CHECK1 30/03/2022 10:42 5169 type 4509 return to supplier AAA1525
CAR_CHECK1 30/03/2022 10:43 5132 date_time 4624 2022-03-30-08.43.00 AAA1525
CAR_CHECK1 30/03/2022 10:43 5174 car group 4629 V AAA1525
CAR_CHECK1 30/03/2022 10:48 5134 car 4632 AAA1525 AAA1525
CAR_CHECK1 30/03/2022 10:48 5135 car km 4633 51389 AAA1525
CAR_CHECK1 30/03/2022 10:48 5142 picture 4634 YES AAA1525
CAR_CHECK1 30/03/2022 10:55 5166 signature 4627 SIGNATURE AAA1525
CAR_CHECK1 01/04/2022 10:42 5169 type 4509 return to supplier CCC1122
CAR_CHECK1 01/04/2022 10:42 5132 date_time 4624 2022-03-30-08.43.00 CCC1122
CAR_CHECK1 01/04/2022 10:42 5174 car group 4629 V CCC1122
CAR_CHECK1 01/04/2022 10:42 5134 car 4632 CCC1122 CCC1122
CAR_CHECK1 01/04/2022 10:42 5135 car km 4633 51389 CCC1122
CAR_CHECK1 01/04/2022 10:42 5142 picture 4634 YES CCC1122
CAR_CHECK1 01/04/2022 10:42 5166 signature 4627 SIGNATURE CCC1122
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

