4D v13.4

subquery

Home

 
4D v13.4
subquery

subquery  


 

 

Command subquer

SELECT [ALL | DISTINCT]
{* | select_item, ..., select_item}
FROM table_reference, ..., table_reference
[WHERE search_condition]
[GROUP BY sort_list]
[HAVING search_condition]
[LIMIT {int_number | ALL}]
[OFFSET int_number]

A subquery is like a separate SELECT statement enclosed in parentheses and passed in the predicate of another SQL statement (SELECT, INSERT, UPDATE or DELETE). It acts as a query within a query and is often passed as part of a WHERE or HAVING clause.

 
PROPERTIES 

Product: 4D
Theme: Syntax rules

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

search_condition
SELECT
select_item
sort_list
table_reference