All about SELECT_SQL

LANSA

All about SELECT_SQL
Example 189 - Rating: common
The Things that Make Up this ExampleTo Execute this ExampleForms/Components for this ExampleSee 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 - techniquesSQL - 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