The following articles mainly describe the advanced usage of the DB2 SELECT statement. First, we will explain it from the creation result table. The following is a detailed description of the article, we hope you will have a better understanding of the advanced usage of the DB2 SELECT statement after browsing.
Advanced usage of SELECT statements in DB2 databases:
1. Create a result table
- create table new_table_name as
- (select * from table_name) definition only;
2. Create a materialized query table MQT)
- create table new_table_name as
- (select * from table_name)
- data initially deferred refresh deferred;
- refresh table new_table_name;
Note: A materialized table is similar to a Query and does not actually form a table. The type is displayed as Query. But it can be used as a table.
3. Copy the table structure
- create table new_table_name like table_name;
The above content is an introduction to the advanced usage of the DB2 SELECT statement. I hope you will find some gains.
The above content describes the advanced usage of the DB2 SELECT statement, hoping to help you in this regard.