Tuesday, 8 March 2016

Return Multiple Rows as a Single Comma-Separated Row

You can use the following SQL to return multiple rows as a single row:

select listagg(<column>, ',') within group (order by <column>) as list
FROM <table>


No comments:

Post a comment