Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# The Syntax of a SELECT Statement

The SELECT syntax supported has the following format:

    SELECT <select list> <FROM clause> [<WHERE clause>] [<GROUP BY clause>] [<ORDER BY clause>] [<LIMIT clause>]

Notice that <FROM clause> is not optional. Use of a SELECT statement with ActiveSpaces is always intended to query data in the data grid and the table to query must always be specified by including <FROM clause>.

The order of rows returned for a query is non-deterministic unless an ORDER BY clause is included in the SELECT statement.

Subtopics

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.