Note: | Single quote marks ( ' ) are used to delimit literal values that are string, and thus are not valid to delimit names. See Literal Values in Conditions or Expressions for more information. |
abs | false | natural | then |
all | first | not | to |
and | first_value | now | trailing |
any | float | nth_value | trim |
array | floor | ntile | true |
as | following | null | trunc |
asc | for | nulls | truncate |
avg | from | on | unbounded |
between | full | or | union |
big_decimal | group | order | unknown |
blob | grouping | outer | upper |
boolean | having | over | using |
by | hour | partition | variance |
byte | hours | pattern | var_pop |
case | in | power | var_samp |
cast | inner | preceding | week |
ceil | integer | range | weeks |
ceiling | intersect | rank | when |
character | is | recursive | where |
character_length | join | ref | window |
char_length | lag | regr_intercept | with |
clob | last | regr_slope | within |
corr | last_value | relative | year |
count | lead | right | years |
covar | leading | round | |
covar_pop | left | row | |
covar_samp | like | rows | |
cross | limit | row_number | |
cube | ln | seconds | |
cume_dist | long | seconds | |
current | lower | select | |
date | matching | sets | |
day | max | shift | |
days | measures | short | |
default | millisecond | slide | |
define | milliseconds | sql_date | |
dense_rank | min | sql_time | |
desc | minus | sql_timestamp | |
distinct | minute | sqrts | |
do | minutes | stddev | |
double | mod | stddev_pop | |
duration | month | stddev_samp | |
else | months | string | |
end | struct | ||
except | substring | ||
exp | sum | ||
explain |