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 analytical expression basics.
EVALUATE <table> [ORDER BY {<expression> [{ASC | DESC}]}[, …]
Following is the list of statements supported in Wyn Enterprise.
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
Arguments
Example
EVALUATE 'Product' ORDER BY 'Product'[Product Name]
Returns all rows and columns from the Product table, ordered by Product Name, as a table.