Integrate Software AG Products Using Digital Event Services : MashZone NextGen Help : Appendix : Legacy Presto components : MashZone NextGen Analytics : RAQL Queries : RAQL Reserved Keywords
RAQL Reserved Keywords
The following SQL keywords are reserved words for RAQL queries. Keywords are shown in lower case. Matching is not case sensitive.
Column and function names in queries that match reserved keywords must be delimited with double quote marks ( " ) to prevent errors in query execution.
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
double
min
slide
all
duration
minus
sqrts
and
else
minute
stddev
any
end
minutes
stddev_pop
array
except
mod
stddev_samp
as
exists
month
string
asc
exp
months
struct
avg
false
natural
sum
between
float
not
then
big_decimal
floor
now
time
blob
following
null
timestamp
boolean
from
on
to
by
full
or
true
byte
group
order
trunc
case
having
outer
truncate
cast
hour
over
unbounded
ceil
hours
partition
union
ceiling
in
pattern
unknown
character
inner
power
using
character_length
integer
preceding
variance
char_length
intersect
range
var_pop
clob
is
recursive
var_samp
count
join
ref
week
cross
left
relative
weeks
current
like
right
when
date
limit
round
where
day
ln
row
window
days
long
rows
with
default
matching
seconds
within
define
max
seconds
year
desc
measures
select
years
distinct
millisecond
shift
do
milliseconds
short
Copyright © 2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback