![]() |
SQL-J Language Reference
|
Reference Manual |
ScalarSubqueryYou can place a ScalarSubquery anywhere an Expression is permitted. A ScalarSubquery turns a SelectExpression result into a scalar value because it returns only a single row and column value. The query must evaluate to a single row with a single column. Sometimes also called an expression subquery. Syntax( Query) Example
-- avg always returns a single value, so the subquery is
-- another ScalarSubquery |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |