Wyn Enterprise User 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 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

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.