XMLAGG - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

Purpose

Performs an aggregate of multiple rows to construct an XML value.

Syntax



XML_value_expr
An instance of the XML type.
ORDER BY
The resulting values are ordered as follows:
  • ASC - in ascending order
  • DESC - in descending order
  • NULLS FIRST - Nulls are ordered first
  • NULLS LAST - Nulls are ordered last
RETURNING CONTENT
The return value is an XQuery document node.
RETURNING SEQUENCE
The return value is a sequence. This is the default.