Centrallix - It's Different than what you Think

Search...

Index...

1. Getting Started
2. Applications Overview
3. Application Components
4. Reports Overview
5. Report Components
6. SQL Language

6.1 SELECT Statements
6.2 WHERE Clause
6.3 FROM Clause
6.4 ORDER BY Clause
6.5 GROUP BY Clause
6.6 HAVING Clause
6.7 Data Types
6.8 Functions and Operators
6.9 Subqueries
6.10 INSERT Statements
6.11 UPDATE Statements
6.12 DELETE Statements
6.13 DECLARE Statements
6.14 EXEC Statements

7. Process Modeling
8. Application Modeling
9. Role-Based Security
10. Business Logic Modeling
11. Other Objects
12. External API's
13. Internal API's

6.4 ORDER BY Clause

(0 comments)

Centrallix supports sorting rows in a SQL result set using the ORDER BY clause.

SELECT :d:name, :d:size from /mydirectory d ORDER BY :d:size

You can specify whether to sort ascending or descending. The default is ascending if not specified.

SELECT :d:name, :d:size from /mydirectory d ORDER BY :d:size ASC

SELECT :d:name, :d:size from /mydirectory d ORDER BY :d:size DESC

Notes Regarding ORDER BY

First, a caveat: In the development version of Centrallix 0.9.0 as of the time of writing of this document, Centrallix does not yet support multi-stage queries, and so sorting support is limited at the present time. Sorting operates properly for an individual data source, but sorting on aggregate fields does not work. Sorting in joined queries is query-dependent.

For data sources which inherently support sorting, such as the relational databases Sybase and MySQL, sorting is performed by the database server. For other data sources, including the filesystem and CSV files, sorting is performed by Centrallix' OSML. Centrallix uses a combined mergesort / selection sort algorithm, which is a stable sort.

Comments...

(none yet)

Add a Comment...

Project Hosting Provided By: