Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# The SQL SELECT Statement

A SQL SELECT statement is used to query data in the data grid. The table to query is determined by parsing the SELECT string when creating the Statement object. The rows that satisfy the query are returned in a ResultSet. A WHERE clause can be used in the SELECT statement to control which rows of a table must be used in the query result. An ORDER BY clause can be appended after the WHERE clause to sort the resulting rows of the query. A LIMIT clause can be appended as the last clause of the SELECT string to control the number of rows ultimately returned by the query.

SQL keywords, table, and column identifiers are not treated as case sensitive when used in a SQL SELECT statement. However, string values are treated as case sensitive and must be surrounded by single quotes.

Subtopics

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