Go to main content
114/114
Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
Y
A
about queries
1
ABS function
1
ADD_ELEMENT function
1
addition operator
1
aggregation
function filters
1
functions
1
multi-level
1
with APPROXCOUNTDISTINCT
1
with COUNT
1
with COUNT_APPROX
1
with COUNTDISTINCT
1
with COUNTDISTINCTMEMBERS
1
APPROXCOUNTDISTINCT function
1
ARB function
1
arithmetic operators
1
AVG function
1
B
best practices
additional tips
1
controlling input size
1
defining constants
1
filtering as early as possible
1
BETWEEN operator
1
Boolean
literal handling
1
operators
1
C
calculate percent change over month
1
CARDINALITY function
1
CASE expression
1
case handling in EQL
1
CEIL function
1
characters in EQL
1
clauses
DEFINE
1
FROM
1
GROUP
1
GROUP BY
1
HAVING
1
JOIN
1
LET
1
ORDER BY
1
PAGE
1
RETURN
1
SELECT
1
WHERE
1
COALESCE expression
1
collections
in FROM clause
1
record sources
1
combining multiple sparse fields into one
1
commenting in EQL
1
CONCAT function
1
controlling input size
1
controlling join size
1
CORRELATION function
1
COS function
1
COUNT_APPROX function
1
COUNTDISTINCT function
1
COUNTDISTINCTMEMBERS function
1
COUNT function
1
CROSS JOIN
1
CUBE extension
1
cumulative sum
1
CURRENT_DATE function
1
CURRENT_TIMESTAMP function
1
D
data types
1
date and time values
constructing
1
using arithmetic operations on
1
DAY_OF_MONTH function
1
DAY_OF_WEEK function
1
DAY_OF_YEAR function
1
DEFINE clause
1
defining constants for best performance
1
DIFFERENCE function
1
DISTANCE function
1
division operator
1
double
data type
1
handling of precision
1
promotion from integer
1
E
EQL
case handling
1
characters
1
commenting
1
concepts
1
handling of inf results
1
handling of NaN results
1
handling of NULL results
1
inter-statement references
1
LOOKUP expressions
1
multi-level aggregation example
1
overview
1
processing order
1
reserved keywords
1
SQL comparison
1
syntax conventions
1
evaluation time and input size
1
EVERY function
1
existential quantifier
1
EXP function
1
expressions
CASE
1
COALESCE
1
GROUPING SETS
1
IN
1
in ORDER BY
1
LOOKUP
1
EXTRACT function
1
F
filtering
geocode
1
performance impact of
1
filters
per-aggregation
1
using results values as
1
FLOOR function
1
follow-on queries
1
FOREACH function
1
FROM_TZ function
1
FROM clause
1
FULL JOIN
1
functions
ABS
1
aggregation
1
APPROXCOUNTDISTINCT
1
ARB
1
arithmetic operators
1
AVG
1
CEIL
1
CONCAT
1
CORRELATION
1
COS
1
COUNT
1
COUNT_APPROX
1
COUNTDISTINCT
1
COUNTDISTINCTMEMBERS
1
CURRENT_DATE
1
CURRENT_TIMESTAMP
1
date and time
1
DAY_OF_MONTH
1
DAY_OF_WEEK
1
DAY_OF_YEAR
1
DISTANCE
1
EXP
1
EXTRACT
1
FLOOR
1
FROM_TZ
1
GROUPING
1
HOUR
1
JULIAN_DAY_NUMBER
1
LATITUDE
1
LN
1
LOG
1
LONGITUDE
1
MAX
1
MEDIAN
1
MILLISECOND
1
MIN
1
MINUTE
1
MOD
1
MONTH
1
numeric
1
PERCENTILE
1
POWER
1
QUARTER
1
RECORD_IN_FAST_SAMPLE
1
ROUND
1
SECOND
1
SIGN
1
SIN
1
SQRT
1
STDDEV
1
string
1
STRING_JOIN
1
SUBSTR
1
SUM
1
SYSDATE
1
SYSTIMESTAMP
1
TAN
1
TO_DATETIME
1
TO_DOUBLE
1
TO_DURATION
1
,
2
TO_GEOCODE
1
TO_INTEGER
1
TO_STRING
1
TO_TIME
1
TO_TZ
1
TRUNC
1
,
2
VARIANCE
1
WEEK
1
YEAR
1
G
geocode
data type
1
filtering
1
sorting by
1
GROUP BY clause
CUBE extension
1
MEMBERS extension
1
ROLLUP extension
1
GROUP clause
1
grouping
by range buckets
1
data into quartiles
1
GROUPING function
1
GROUPING SETS expression
1
H
HAS_REFINEMENTS
1
HAVING clause
1
HOUR function
1
I
identifier handling
1
important concepts
1
IN expression
1
inf, EQL handling of
1
INNER JOIN
1
integer promotion to double
1
INTERSECTION function
1
inter-statement references, EQL
1
IS_EMPTY function
1
IS_MEMBER_OF function
1
IS_NOT_EMPTY function
1
IS EMPTY function
1
IS NOT EMPTY function
1
J
JOIN clause
1
joining data from different types of records
1
join size constraints
1
JULIAN_DAY_NUMBER function
1
L
LATITUDE function
1
LEFT JOIN
1
LET clause
1
linear regression in EQL
1
literals
1
LN function
1
LOG function
1
LONGITUDE function
1
LOOKUP expression
1
M
manipulating records in a dynamically computed range value
1
MAX function
1
MEDIAN function
1
MEMBERS extension
1
MILLISECOND function
1
MIN function
1
MINUTE function
1
MOD function
1
MONTH function
1
multi-level aggregation example
1
multiplication operator
1
N
NaN, EQL handling of
1
NULL values
and sets
1
EQL handling of
1
numeric
functions
1
literal handling
1
O
operations, date and time
1
operators
arithmetic
1
Boolean
1
precedence order
1
ORDER BY clause
1
order of processing in EQL
1
overview of queries
1
P
PAGE clause
PERCENT modifier
1
Top-K queries
1
PERCENTILE function
1
PERCENT modifier
1
pie chart segmentation with IN filters
1
POWER function
1
precedence rules for operators
1
Q
QUARTER function
1
queries
1
query by age
1
query processing order
1
R
RECORD_IN_FAST_SAMPLE function
1
re-normalization
1
reserved keywords
1
result values used as filters
1
RETURN clause
1
RIGHT JOIN
1
ROLLUP extension
1
ROUND function
1
running sum
1
S
SATISFIES function
1
SECOND function
1
SELECT clause
1
SET_INTERSECTIONS function
1
SET_UNIONS function
1
SET function
1
set functions
ADD_ELEMENT
1
APPROXCOUNTDISTINCT
1
ARB
1
CARDINALITY
1
COUNT
1
COUNT_APPROX
1
COUNTDISTINCT
1
COUNTDISTINCTMEMBERS
1
DIFFERENCE
1
EVERY
1
FOREACH
1
INTERSECTION
1
IS_EMPTY
1
IS_MEMBER_OF
1
IS_NOT_EMPTY
1
IS EMPTY
1
IS NOT EMPTY
1
SET
1
SET_INTERSECTIONS
1
SET_UNIONS
1
SINGLETON
1
SOME
1
SUBSET
1
TRUNCATE_SET
1
UNION
1
sets
constructing from single-assign attributes
1
constructor
1
data types
1
grouping by
1
sort order
1
SIGN function
1
SIN function
1
SINGLETON function
1
SOME function
1
SQL comparison
1
SQRT function
1
state names in FROM clause
1
STDDEV function
1
string
data type
1
literal handling
1
sort order
1
STRING_JOIN function
1
structured literal handling
1
SUBSET function
1
SUBSTR function
1
subtraction operator
1
SUM function
1
syntax conventions
1
SYSDATE function
1
SYSTIMESTAMP function
1
T
TAN function
1
terminology, EQL
1
TO_DATETIME function
1
TO_DOUBLE function
1
TO_DURATION function
1
,
2
TO_GEOCODE function
1
TO_INTEGER function
1
TO_STRING function
1
TO_TIME function
1
TO_TZ function
1
Top-K queries
1
TRUNCATE_SET function
1
TRUNC function
1
,
2
U
UNION function
1
universal quantifier
1
use cases
calculate percent change over month
1
combining multiple sparse fields into
1
grouping by range buckets
1
grouping data into quartiles
1
joining data from different types of
1
linear regression
1
manipulating records in a dynamically computed
1
pie chart segmentation
1
query by age
1
re-normalization
1
running sum
1
using arithmetic operations on date and time values
1
V
VARIANCE function
1
W
WEEK function
1
WHERE clause
1
WITH UNPAGED COUNT modifier for RETURN
1
Y
YEAR function
1
Scripting on this page enhances content navigation, but does not change the content in any way.