The SELECT statement of the complex event processing language describes continuous queries to the event stream, similar to the way queries to database tables are coded in SQL SELECT statements.
An overview of the SELECT statement syntax is shown below. Syntax details are shown under the various clauses.
Syntax:
[annotation]
[insert into insertDefinition]
select propertyAndExpressionList
from eventStreamDefinitionAndItsJoin
[where conditionExpression]
[group by groupingExpressionList]
[having groupingCondition]
[output outputDefinition]
[order by sortExpressionList]
[limit numberOfRows]
