Reference Guide
>
TDV SQL Keywords and Syntax
TDV SQL Keywords and Syntax
This topic describes the syntax for the SQL keywords supported by TDV:
•
BETWEEN
•
CREATE TABLE
•
CREATE TABLE AS SELECT
•
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