TDV SQL Keywords and Syntax

This topic describes the syntax for the SQL keywords supported by TDV:

• BETWEEN
• CREATE [OR REPLACE] TABLE
• CREATE [OR REPLACE] TABLE AS SELECT
• CREATE TEXT INDEX
• CROSS JOIN
• DELETE
• DISTINCT
• DROP
• EXCEPT
• FULL OUTER JOIN
• GROUP BY
• HAVING
• INNER JOIN
• INSERT
• INSERT, UPDATE, and DELETE on Views
• INTERSECT
• LEFT OUTER JOIN
• OFFSET and FETCH
• ORDER BY
• PIVOT
• UNPIVOT
• RIGHT OUTER JOIN
• SELECT
• SELECT (Virtual Columns)
• SEMIJOIN to a Procedure
• UNION
• UNION ALL
• UPDATE
• WHERE
• WITH