SELECT array_to_string(array (select unnest(array_agg(loading_plan_no))), '/') as ltgno,
array_to_string(array (select unnest(array_agg(freight_forwarder))), '/') as forwarder
FROM plan_ltg WHERE loading_no = ''
还可以分组:
SELECT array_to_string(array (select unnest(array_agg(loading_plan_no))), '/') as ltgno,
array_to_string(array (select unnest(array_agg(freight_forwarder))), '/') as forwarder
FROM plan_ltg WHERE loading_no = ''
还可以分组: