db2Parse comma-separated values in a column into multiple rows
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
Parse comma-separated values in a column into multiple rows Related Examples
This modified text is an extract of the original Stack Overflow Documentation created by following contributors and released under CC BY-SA 3.0
This website is not affiliated with Stack Overflow
Email: tutorialpedia@outlook.com