Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
nameME_ELT_KI_Underscore_Refs
pageELT Snap Pack

Snap Input and Output

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
Input 

Document

  • Min: 1
  • Max: 1
  • ELT Select
  • ELT Copy
The SQL query in which you want to add the ORDER BY keyword.
Output

Document

  • Min: 1
  • Max: 1
  • ELT Insert-Select
  • ELT Unique
The incoming SQL query with the ORDER BY keyword.

...