Using derived tables in Actuate SQL

A derived table is a virtual table that is calculated on the fly from a SELECT statement. A derived table can be used in a FROM clause, WHERE clause, HAVING clause, or subquery, for example:

SELECT Column01

FROM (Derived_table)

A derived table can have parameters.

Copyright Actuate Corporation 2012