Netezza
YES
NO
NO
NO
NO
NO
NO
YES
INNER JOIN
YES
YES
NO
NO
NO
YES
YES
YES
YES
YES
YES
YES
YES
YES
NO
NO
NO
YES
NO
NO
YES
YES
TO_NUMBER(TO_CHAR($D,'YYYY'),'9999')
TO_NUMBER(TO_CHAR($D,'Q'),'9')
TO_NUMBER(TO_CHAR($D,'MM'),'99')
+
-
*
/
NOT
OR
AND
IS NOT NULL
IS NULL
>=
<=
=
<>
>
<
IN
NOT IN
LIKE
NOT LIKE
BETWEEN AND
NOT BETWEEN AND
min($1)
max($1)
avg($1)
sum($1)
count($1)
{fn ascii($1)}
{fn char($1)}
{fn concat($1,$2)}
{fn left($1,$2)}
{fn ltrim($1)}
nvl($1,$2)
nvl($1,$2)
nvl($1,$2)
{fn length($1)}
{fn locate($1,$2)}
{fn lcase($1)}
{fn repeat($1,$2)}
{fn right($1,$2)}
{fn rtrim($1)}
{fn substring($1,$2,$3)}
{fn ucase($1)}
{fn abs($1)}
{fn acos($1)}
{fn asin($1)}
{fn atan($1)}
{fn atan2($1,$2)}
{fn cos($1)}
{fn ceiling($1)}
{fn exp($1)}
{fn floor($1)}
{fn log($1)}
{fn mod($1,$2)}
{fn pi()}
{fn rand($1)}
{fn sign($1)}
{fn sin($1)}
{fn sqrt($1)}
{fn tan($1)}
to_date($1,$2)
add_months($1,$2)
last_day($1)
next_day($1,$2)
@prompt($1,'A',,,)
@prompt($1,'N',,,)
@prompt($1,'D',,,)
cast($1 as char(20))
cast($1 as char(20))
NVL($1,$2)