About

insert is a data manipulation language statement.

In an INSERT statement, you define the values with:

• the VALUES expression
• or a select statement

Articles Related

Example

• Derby

create table t(t char(1));
INSERT INTO t SELECT * FROM (VALUES 'a','c','b') t ORDER BY 1;