17.10 - XMLAGG Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)
XMLAGG (
  XML_value_expr
  [ ORDER BY order_by_spec [,...] ]
  [ RETURNING { CONTENT | SEQUENCE } ]
)

Syntax Elements

order_by_spec
sort_key [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
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.
sort_key