Order by

SQL ORDER BY timestamp clause
An clause in SQL specifies that a SQL statement returns a result set with the rows being sorted by the values of one or more columns.wikipedia
9 Related Articles

Result set

SQL result sets
An clause in SQL specifies that a SQL statement returns a result set with the rows being sorted by the values of one or more columns.
The clause can be used in a query to impose a certain sort condition on the rows.

View (SQL)

viewviewsdatabase view
Although some database systems allow the specification of an clause in subselects or view definitions, the presence there has no effect.
Therefore, an ORDER BY clause in the view definition is meaningless; the SQL standard (SQL:2003) does not allow an ORDER BY clause in the subquery of a CREATE VIEW command, just as it is refused in a CREATE TABLE statement.

SQL

Structured Query LanguageSQL databaseSQL Databases
An clause in SQL specifies that a SQL statement returns a result set with the rows being sorted by the values of one or more columns.

User-defined function

UDFUDFsuser defined
The sort criteria can be expressions, including column names, user-defined functions, arithmetic operations, or expressions.

Database

database management systemdatabasesDBMS
Without this clause, the relational database system may return the rows in any order.

SQL:2003

SQLSQL standard2003 version of SQL
The only exception are constructs like (not standardized in SQL:2003) which allow the propagation of sort criteria through nested subselects.

Null (SQL)

NULL NULLs
The SQL standard's core functionality does not explicitly define a default sort order for Nulls.

Table (database)

tabletablesdatabase table
However, the database system does not guarantee any ordering of the rows unless an clause is specified in the statement that queries the table.

Event-driven SOA

enriching messageshighly evolvableNew technology
If A causes B, and causality must occur within N number of transactions, then SQL ORDER BY timestamp clause creates a result set that increments a counter of all transactions that occurred within a timeframe, N number of matching B to occurrence A transactions.