db2將列中以逗號分隔的值解析為多行


句法

  • WITH CTE_namecolumn_name [,...])AS(
  • SELECT column_name [,...] FROM base_table
  • UNION ALL
  • SELECT column_name [,...] FROM CTE_name
  • WHERE < 遞歸限制條件 >
  • SELECT column_name [,...] FROM CTE_name

將列中以逗號分隔的值解析為多行 相關例子