Update Set for a column

Question

This is a sample table and I would like to update the column 'TYPE' as like the value which is there 'STOCKIN' /'STOCKOUT' for the particular DOCNUM in each row.

Sample Table

CODE	DOCNUM	TYPE
Z01	NUM12	stockin
Z01	NUM12	null
Z01	NUM12	null
Z01	NUM12	null
Z01	NUM134	stockout
Z01	NUM134	null
Z01	NUM134	null
Z01	NUM134	null

Expected table

CODE	DOCNUM	TYPE
Z01	NUM12	stockin
Z01	NUM12	stockin
Z01	NUM12	stockin
Z01	NUM12	stockin
Z01	NUM134	stockout
Z01	NUM134	stockout
Z01	NUM134	stockout
Z01	NUM134	stockout

Please help me how can I update the column Type for each row as per the DOCNUM.

What's the logic to fill those rows? First not null value, min value, max value, anything else? Your question is too vague. — Jonas Metzler
– Jonas Metzler, Commented Oct 18, 2024 at 11:20

Alvaro · Accepted Answer · 2024-10-18 10:18:47Z

0

To update the ‘TYPE’ column based on the ‘DOCNUM’ in your table, you can use SQL to achieve this. Here’s a simple SQL query to update the table.

UPDATE sample_table
SET TYPE = (
    SELECT DISTINCT TYPE
    FROM sample_table AS t2
    WHERE t2.DOCNUM = sample_table.DOCNUM
    AND t2.TYPE IS NOT NULL
)
WHERE TYPE IS NULL;

click here to see full code

answered Oct 18, 2024 at 10:18

Alvaro

1509 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update Set for a column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related