Forms/Components for this Example

Forms/Components for this Example

See Also: SELECT_SQL command in the Technical Reference Guide

Keyword/method	Description
DISTINCT	You can use DISTINCT to eliminate duplicate field values
Calculation	You can perform calculations on the retrieved data
AND and OR	You can use AND and OR operators to construct complex queries
NOT	You can use the NOT operator in the WHERE clause to exclude data
Join	You can join files before retrieving the data
Auto Join	You can join a table to itself to compare data
ANY	You can use the ANY parameter to make a subquery
ALL	You can use the ALL parameter to make a subquery
BETWEEN	You can use BETWEEN operator in the WHERE clause to retrieve data between specified values
IN	You can use IN to retrieve fields that match listed values
LIKE	You can use LIKE to retrieve records that match generic criteria.
SQUARE ROOT	You can use mathematical functions such as square root to manipulate the retrieved data
SUBSTRING	You can substring the retrieved values
Column Functions	You can use aggregate functions to summarize the results of a query rather than listing all of the rows