All about SELECT_SQL
Example 189 - Rating: common
These examples demonstrate the use of the SELECT_SQL command. The examples are available as functions or forms.
They cover the following SQL keywords and methods: DISTINCT, Calculation, AND, OR, NOT, Joining, Sub selection, BETWEEN, LIKE, IN (list), SQRT, SUBSTR, SUM, AVG, COUNT, MAX, MIN.
Notes and Suggestions
Note that the use of sub-selection requires the use of different program versions for the PC and the iSeries.
For information on the use of variables within SELECT_SQL statements, see Generic Searching with SQL..
Keywords
Example 189 - Rating: common
| The Things that Make Up this Example | To Execute this Example | Forms/Components for this Example | See Also: SELECT_SQL command in the Technical Reference Guide |
These examples demonstrate the use of the SELECT_SQL command. The examples are available as functions or forms.
They cover the following SQL keywords and methods: DISTINCT, Calculation, AND, OR, NOT, Joining, Sub selection, BETWEEN, LIKE, IN (list), SQRT, SUBSTR, SUM, AVG, COUNT, MAX, MIN.
Notes and Suggestions
Note that the use of sub-selection requires the use of different program versions for the PC and the iSeries.
For information on the use of variables within SELECT_SQL statements, see Generic Searching with SQL..
Keywords
| SELECT_SQL - techniques | SQL - techniques |
| DISTINCT (SELECT_SQL) | Calculation (SELECT_SQL) |
| AND (SELECT_SQL) | OR (SELECT_SQL) |
| NOT (SELECT_SQL) | Joining (SELECT_SQL) |
| Sub-selection (SELECT_SQL) | BETWEEN (SELECT_SQL) |
| LIKE (SELECT_SQL) | IN (list) (SELECT_SQL) |
| Square Root (SELECT_SQL) | SUBSTR (SELECT_SQL) |
| SUM (SELECT_SQL) | Average (AVG) (SELECT_SQL) |
| COUNT (SELECT_SQL) | MAX (SELECT_SQL) |
| MIN (SELECT_SQL) | Example 189 |