Concat all column values in sql

by

In SQL Server:

SELECT  col1 AS [text()]
FROM    foo
FOR XML PATH ('')

In MySQL:

SELECT  GROUP_CONCAT(col1 SEPARATOR '')
FROM    foo

In PostgreSQL:

SELECT  array_to_string
        (
        ARRAY
        (
        SELECT  col1
        FROM    foo
        ), ''
        )

In Oracle:

SELECT  *
FROM    (
        SELECT  col1, ROW_NUMBER() OVER(ORDER BY 1) AS rn
        FROM    foo
        MODEL
        DIMENSION BY
                (rn)
        MEASURES
                (col1, col1 AS group_concat, 0 AS mark)
        RULES UPDATE (
                group_concat[rn > 1] =  group_concat[CV() - 1] || col1[CV()],
                mark[ANY] = PRESENTV(mark[CV() + 1], 0, 1)
                )
        )
WHERE   mark = 1

More Related Contents:

  1. How to use GROUP BY to concatenate strings in MySQL?
  2. MySQL Results as comma separated list
  3. How can I combine multiple rows into a comma-delimited list in Oracle? [duplicate]
  4. Concatenate row values T-SQL
  5. Ms Access Query: Concatenating Rows through a query
  6. Oracle SQL, concatenate multiple columns + add text
  7. How to concatenate columns in a Postgres SELECT?
  8. How can multiple rows be concatenated into one in Oracle without creating a stored procedure? [duplicate]
  9. Concatenate and group multiple rows in Oracle [duplicate]
  10. Show a one to many relationship as 2 columns – 1 unique row (ID & comma separated list)
  11. How can I combine multiple rows into a comma-delimited list in SQL Server 2005?
  12. Concatenate results from a SQL query in Oracle
  13. Concat field value to string in SQL Server
  14. concatenate two database columns into one resultset column
  15. Combine two columns and add into one new column
  16. String concatenation does not work in SQLite
  17. SQL, How to Concatenate results?
  18. Get the mentioned output by SQL query
  19. Decrease salary using a SQL query
  20. Reason for Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause [duplicate]
  21. ORA-12560: TNS:protocol adaptor error
  22. Select statement to find duplicates on certain fields
  23. How to use DISTINCT and ORDER BY in same SELECT statement?
  24. Does MS SQL Server’s “between” include the range boundaries?
  25. basic recursive query on sqlite3?
  26. Check for file exists or not in sql server?
  27. Why doesn’t SQL support “= null” instead of “is null”?
  28. PostgreSQL: Case insensitive string comparison
  29. Difference between “read commited” and “repeatable read” in SQL Server
  30. Subtract hours from the now() function

Leave a Comment