db2 Parse comma-separated values in a column into multiple rows
30% OFF - 9th Anniversary discount on Entity Framework Extensions until December 15 with code: ZZZANNIVERSARY9
Syntax
- WITH CTE_name (column_name[,...]) AS (
- SELECT column_name[,...] FROM base_table
- UNION ALL
- SELECT column_name[,...] FROM CTE_name
- WHERE <recursion limiting condition>
- )
- SELECT column_name[,...] FROM CTE_name
