SQL Operators - Epsio¶
SELECT ¶
WHERE ¶
JOIN ¶
GROUP BY ¶
GROUP BY
supports the following aggregations:
COUNT
SUM
MAX
MIN
AVG
ARRAY_AGG
JSON_AGG
STRING_AGG
Note that these aggregations are also available without a GROUP BY
expression
UNION/UNION ALL ¶
ORDER BY ... LIMIT ¶
To useORDER BY
there must be a LIMIT
attached to it, as (similar to Postgres Materialized Views) Epsio does not maintain ordering within the result table since this is not possible in MySQL/Postgres. With a LIMIT
, Epsio will ensure the top/bottom x records are within the table, but not their ordering. DISTINCT ¶
CTEs ¶
Subqueries and Views ¶
Window Functions ¶
Currently supported window functions are:-
ROW_NUMBER
-
LAG
-
RANK