DB2 Quick Guide

SQL Commands

Comments

/* */
--

Select

select co1, co2 from tbl where fld = 3;

Insert (values)

insert into tbl (co1, co2) values (1, 'one');
insert into tbl (co1, co2)
values ((select id from tbl2 where something = 'something'), 'one');

Delete

delete from tbl where co1 = 1;