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 analytical expression basics.

EVALUATE <table> 
[ORDER BY {<expression> [{ASC | DESC}]}[, …]

Following is the list of statements supported in Wyn Enterprise.

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

Example

EVALUATE
    'Product'
ORDER BY
    'Product'[Product Name]

Returns all rows and columns from the Product table, ordered by Product Name, as a table.