WHERE
HAVING
LIMIT
OFFSET
GROUP BY
1
, 2
), a MySQL dialect extension.ORDER BY
1
, 2
), a MySQL dialect extension.DISTINCT
ALL
LEFT OUTER
, RIGHT OUTER
, INNER
, NATURAL
, and CROSS JOINS
are supported. FULL OUTER
joins are not supported.UNION
IF
CASE
NULLIF
COALESCE
IFNULL
AND
OR
LIKE
IN
INTERVAL
%
&
*
+
->>
->
-
/
:=
<<
<=>
<=
<>
, !=
<
=
>=
>>
>
^
AVG()
BIT_AND()
BIT_OR()
BIT_XOR()
COUNT()
COUNT(DISTINCT)
GROUP_CONCAT()
JSON_OBJECT_AGG()
JSON_ARRAY_AGG()
MAX()
MIN()
STD()
STDDEV()
STDDEV_POP()
STDDEV_SAMP()
SUM()
VAR_POP()
VAR_SAMP()
VARIANCE()
CUME_DIST()
DENSE_RANK()
FIRST()
FIRST_VALUE
LAG
LAST_VALUE()
LAST()
LEAD()
NTH_VALUE()
NTILE()
PERCENT_RANK()
RANK()
ROW_NUMBER()