Forms/Components for this Example
All about SELECT_SQL | The Things that Make Up this Example | To Execute 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 |