In this article
...
Use this Snap to add the ORDER BY keyword to an existing query. The ORDER BY keyword enables you to sort records in ascending or descending order of a specified column's value. Additionally, the Snap also enables you to specify whether null value records are displayed first or last. This Snap also allows you to preview the result of the output query. You can validate the modified query using this preview functionality.
Prerequisites
None.
Limitations
...
None.
Known Issues
...
Multiexcerpt include macro | ||||
---|---|---|---|---|
|
Snap Input and Output
Input/Output | Type of View | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document |
|
| The SQL query in which you want to add the ORDER BY keyword. |
Output | Document |
|
| The incoming SQL query with the ORDER BY keyword. |
...