1.0

INSERT INTO TRADE.CUSTOMERS(CID ,CUST_NAME , ADDR ,TID)
VALUES (1, 'J. Pearson', 'VMWare', 1)
-- Insert two new customers using one statement
-- into the CUSTOMER table as in the previous example,
-- but do not assign value to 'SINCE' field of the new
customer.
INSERT INTO TRADE.CUSTOMERS (CID ,CUST_NAME , ADDR ,TID)
VALUES (1, 'J. Pearson' , 'VMWare', 1),
(2, 'David Y.' , 'VMWare', 1)
-- Insert the DEFAULT value for the LOCATION column
INSERT INTO TRADE.CUSTOMERS
VALUES (1, 'J. Pearson', DEFAULT, 'VMWare',1)
Query
Create a virtual table based on existing tables or constants built into tables.
Syntax
{
( Query )
|
SelectExpression | VALUES Expression
}
Note: Using Union, Intersect, or Except is not supported in this release of SQLFire, even though SQLFire
does not throw a syntax error. See SQL Language Limitations on page 653.
Description
A query creates a virtual table based on existing tables or constants built into tables.
ScalarSubquery
You 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.
TableSubquery
A TableSubquery is a subquery that returns multiple rows.
Unlike a ScalarSubquery, a TableSubquery is allowed only with EXISTS, IN, or quantified comparisons.
When used with EXISTS, it returns multiple columns only if you use * to return the multiple columns.
When used with IN or quantified comparisons, it must return a single column.
Note: Using TableSubquery as a TableExpression in a FROM clause is not supported, even though this
does not throw a syntax error.
481
SQL Language Reference