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 |