16.20 - XMLAGG - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1140-162K
Language
English (United States)

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.