FOR XML examples

The following examples show how the FOR XML clause can be used in a SELECT statement.

  • The following example shows how the FOR XML clause can be used in a subquery:

    SELECT XMLELEMENT(
   NAME root,
      (SELECT * FROM Employees
       FOR XML RAW));

  • The following example shows how the FOR XML clause can be used in a query with a GROUP BY clause and aggregate function:

    SELECT Name, AVG(UnitPrice) AS Price
FROM Products
GROUP BY Name
FOR XML RAW;

  • The following example shows how the FOR XML clause can be used in a view definition:

    CREATE VIEW EmployeesDepartments
AS SELECT Surname, GivenName, DepartmentName
FROM Employees JOIN Departments
ON Employees.DepartmentID = Departments.DepartmentID
FOR XML AUTO;
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0