The optional order by clause enables you to sort the results in ascending or descending order.In a continuous query, each set of ordered results in a window constitutes one batch of results. For an example, see Example Showing Batching of Return Values.
In the above example, each row in the result shows the ID of a customer who has placed three or more orders each of which contained 5 or more lines.
Copyright © TIBCO Software Inc. All Rights Reserved.