Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Interactive SQL Online Help Interactive SQL Version 16.0 » Query Editor Help

ORDER BY tab

Use this tab to sort the rows in your result set.

Dialog components

About ORDER BY conditions

Each item in the ORDER BY list can be labeled as an up arrow for ascending order (the default) or a down arrow for descending order. To change the order from ascending to descending, double-click the arrow. Alternatively, you can select the arrow and press F2.

The only way to ensure that rows are returned in a particular order is to use ORDER BY. In the absence of an ORDER BY clause, Adaptive Server Enterprise returns rows in whatever order is most efficient. This means that the appearance of result sets may vary depending on when you last accessed the row and other factors.

Additional information

For more information, see Introducing the Query Editor.