- Getting Started
- Administration Guide
- User Guide
- Developer Guide
Statements
With analytical expressions, you can query and return the data defined by a table expression. Before learning about queries, it is important for you to have a solid understanding of Wyn analytical expression basics.
Syntax
EVALUATE <table>
[ORDER BY {<expression> [{ASC | DESC}]}[, …]Following is the list of statements supported in Wyn Enterprise.
EVALUATE(Required)
At the most basic level, an analytic expression query is an EVALUATE statement containing a table expression.
Syntax
EVALUATE <table>Arguments
Term | Definition |
|---|---|
table | A table or a function that return value is a table. |
Examples
EVALUATE 'Product'This will return all rows and columns from the Product table, as a table.
ORDER BY (optional)
The optional ORDER BY keyword defines one or more expressions used to sort query results. Any expression that can be evaluated for each row of the result is valid.
Syntax
EVALUATE <table>
[ORDER BY {<expression> [{ASC | DESC}]}[, …]Arguments
Argument | Description |
|---|---|
expression | Any expression that returns a single scalar value. |
ASC | Sorts in ascending order. This is the default sort order. |
DESC | Sorts in descending order. |
Example
EVALUATE
'Product'
ORDER BY
'Product'[Product Name]Returns all rows and columns from the Product table, ordered by Product Name, as a table.