DB2 SQL BASIC — 2 DML

SELECT Statement

SQL SELECT Statement is a form of SQL QUERY which gives access to a result set(Temporary table). We can use SQL SELECT to look inside the table or create a new table based on the result set of queries.

There are 3 components of SQL SELECT:

  1. SubSelect

SubSelect

SubSelect is most basic form of SQL SELECT. Just simple select statement with minimum options.Here is how IBM describes…