...
Order directions ASC and DESC are case-sensitive!
To limit the number of records returned a LIMIT operator is used.
| Info |
|---|
You can also use a predefined macro field for limiting records count returned |
- Example: f1 ASC, f2 DESC - will sort the dataset by f1 field values in ASC order and by f2 in DESC order
- Example2: f1 ASC, f2 DESC LIMIT 2 - will sort the dataset by f1 field values in ASC order and by f2 in DESC order and limit the number of records returned to 2
- Example3: LIMIT 2 - will limit the number of records returned to 2
- Example4: created DESC - will sort by record's date created in descending order
...