hi
i want one final table from this
load
order_id
concat(serial, ‘,’) as finalserial
from abc
group by order_id
load
Order_no & order-month
concat(serial, ‘,’) as finalserial
from abc
group by Order_no & order-month
but I need final table with only order_id but both finalserial and no null fields
load
order_id
finalserial
from abc