4.2
Ask or search…
K
Links
Comment on page

SQL Features Matrix

HarperDB provides access to most SQL functions, and we’re always expanding that list. Check below to see if we cover what you need. If not, feel free to add a Feature Request.
INSERT
Text
Values - multiple values supported
Sub-SELECT
UPDATE
Text
SET
Sub-SELECT
Conditions
Date Functions*
Math Functions
DELETE
Text
FROM
Sub-SELECT
Conditions
SELECT
Text
Column SELECT
Aliases
Aggregator Functions
Date Functions*
Math Functions
Constant Values
Distinct
Sub-SELECT
FROM
Text
Multi-table JOIN
INNER JOIN
LEFT OUTER JOIN
LEFT INNER JOIN
RIGHT OUTER JOIN
RIGHT INNER JOIN
FULL JOIN
UNION
Sub-SELECT
TOP
WHERE
Text
Multi-Conditions
Wildcards
IN
LIKE
Bit-wise Operators AND, OR
Bit-wise Operators NOT
NULL
BETWEEN
EXISTS,ANY,ALL
Compare columns
Compare constants
Date Functions*
Math Functions
Sub-SELECT
GROUP BY
Text
Multi-Column GROUP BY
HAVING
Text
Aggregate function conditions
ORDER BY
Text
Multi-Column ORDER BY
Aliases
Date Functions*
Math Functions