Home > database >  Explodes the use of SQL type of the array data is split into multiple lines
Explodes the use of SQL type of the array data is split into multiple lines

Time:03-02

- explodes the array type data
[" 1016144855573971547 ", "10161448637575969739"] into multiple lines

Format: commodity 1 1016144855573971547
Commodity 1 10161448637575969739


The SELECT GDS_CD,
STATIS_DATE,
Explodes (VISITOR_ID_LST) AS VISITOR_ID
The FROM BR. Dd_D
WHERE STATIS_DATE='20200222')
GROUP BY GDS_CD STATIS_DATE
  • Related