4D v14

select_item

Home

 
4D v14
select_item

select_item  


 

 

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

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

 
PROPERTIES 

Product: 4D
Theme: Syntax rules

 
SEE ALSO 

arithmetic_expression
SELECT
sql_name
sql_string

 
ARTICLE USAGE

4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)