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 |