4D Doc Center : select

Home

4D v14

select_item



	Command select_itearithmetic_expression [[AS] {sql_string \|sql_name}]

Description

A select_item specifies one or more items to be included in the results. A column is generated for every select_item passed. Each select_item consists of an arithmetic_expression. You can also pass the optional AS keyword to specify the optional sql_string or sql_name to be given to the column. (Passing the optional sql_string or sql_name without the AS keyword has the same effect).

Example

Here is an example which creates a column named Movie_Year containing movies released in the year 2000 or more recently:

 ARRAY INTEGER(aMovieYear;0)

 Begin SQL

    SELECT Year_of_Movie AS Movie_Year

    FROM MOVIES

    WHERE Movie_Year >= 2000

    ORDER BY 1

    INTO :aMovieYear;

 End SQL