Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.0

# The WHERE Clause

A WHERE clause is used to determine whether a row of a table must be used when composing the results of a query.

When applied to the row of a table, the WHERE clause must result in a boolean value indicating whether a row must be used when calculating the results of a query. The following WHERE clause syntax is supported by ActiveSpaces:

WHERE [NOT] <predicate> [ AND | OR [NOT] <predicate> ] . . .

A predicate is a condition expression that evaluates to true or false. If the predicate evaluates to true for a row, that row is used when calculating the results of the query. For example:

     city='Chicago'
     percent<=75.0

The AND and OR operators are used to filter rows based on more than one condition. For example:

     city='Chicago' AND lastname='Dailey'

The NOT operator includes a row if the condition is not true. For example:

    NOT city='Chicago'

When you create an SQL statement, the efficiency of the SQL statement depends on how well you construct a WHERE clause. For example, a WHERE clause must be used to prevent a full table scan from being done. For more information about constructing an efficient WHERE clause, see Tips on Constructing an Efficient WHERE Clause.
Subtopics

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

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